Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

AnalyticsReportFilter Date/DateTime filters format

edited Jan 20, 2012 8:48PM in Reporting & Analytics for B2C Service 10 comments

Content

I cannot seem to get the reports to filter properly by DATE or DATETIME datatypes.  What format do we need to send the filter value in as???

 

I've used the following but none seem to work:

09/08/2011

2011-09-08

20110908

20110908T00:00:00Z

2011-09-08T00:00:00Z

and others ...

I've tried operators = and RANGE but no records are ever returned.  I've also tried defining the DataType as STRING but either all records are returned or none. 

The DataType from the Report Definition is Date Time.

All other datatypes we've tested work fine but the date fields are not cooperating.

 

Please advise.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!