Potentials closing by this month

Zoho CRM


Zoho CRM is a cloud CRM developed by ZOHO Corporation, and having such features as procurement, inventory, etc.

Potentials Closing by this Month

Query Text

SELECT t."Potential Name", t."Account Name", t."Potential Owner", t.Stage, t.Probability, t.Amount, t."Closing Date"
  FROM Potentials AS t
WHERE (date(date(t."Closing Date"), 'start of month') = date('now', 'localtime', 'start of month') AND t.Stage != 'Closed Lost' AND t.Stage != 'Closed Won')
ORDER BY t."Closing Date", t."Potential Name"

Open Query