function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
CRMUser23CRMUser23 

getcount on createddate

I am trying to get rec count between two dates thru an s-control.
 
When I use THIS_MONTH it works fine but when added "WHERE IsClosed = True AND CreatedDate > 2007-01-01"   the scrupt doesn't work.
 
Please help.
RickyGRickyG
Can you give a little more code so we can understand the context?
SuperfellSuperfell
CreatedDate is a dateTime, so you probably need something like (depending on which TZ you're in)

WHERE IsClosed = True AND CreatedDate > 2007-01-01T00:00:00Z
CRMUser23CRMUser23
Simon, 
Thankyou. I added TZ and it works now.