All Leads in current fiscal year

Dynamics CRM


Dynamics CRM is a widely used cloud CRM from Microsoft, focused on Sales, Marketing, and Service (help desk) sectors.

Display all the leads created in the current fiscal year

Query Text

SELECT lead.fullname, lead.subject AS Topic, lk_leadbase_createdby.fullname AS Owner, lead.statuscode AS Status_Reason, lead.createdon
  FROM lead
LEFT OUTER JOIN systemuser AS lk_leadbase_createdby ON lead.createdby = lk_leadbase_createdby.systemuserid
WHERE (date(date(lead.createdon), 'start of year') = date('now', 'localtime', 'start of year'))
ORDER BY lead.fullname

Open Query