Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
AnalyticsReportFilter Date/DateTime filters format — Cloud Customer Connect
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

Accepted answer
15
Views
10
Comments
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!