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