+ 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.