Symptom
You query a report via OData, however when you check the result, you notice that date time fields are shown in the wrong format. So for example, instead of showing 2019-01-01T00:00:00, the result might return /Date (1545523200000)/
Environment
-
SAP Business ByDesign
- SAP Cloud for Customer
Reproducing the Issue
Enter your OData URL which may look like this:
www.<enter your system URL here>/sap/byd/odata/ana_businessanalytics_analytics.svc/RP<enter your report ID here>QueryResults?$top=1000&$format=json
Cause
You have changed the format from xml to JSON by using $format=json. There is no specific date format provided by JSON.
Resolution
Fields of the type Edm.DateTime will always be shown in this format if you select JSON. The format shows the number of seconds since January 1st, 1970 UTC.
You can change the format back to xml if you leave out the operand $format=json in your OData query.
Keywords
report, business analytics, data source, date, date time, date-time, edm.datetime, odata , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem