Date/Date & Time native values retrieved as integers

[florent-guinard]

We have a Worksheet with Date/Date & Time dimensions used with the 'D/M/YY' display:

When we try to retrieve the summary/underlying data of this Worksheet with the Embedding API we get integer native values in the YYYYMMDD format:

instead of the expected "date/datetime" type and Date values we get when we use another display option:

Link to the test project: https://glitch.com/edit/#!/thoughtful-remarkable-lightning

The test Workbook: Workbook date _ datetime.zip

[bcantoni]

We believe this is working as designed. The underlying data is not aware of the desired viz date format.

[florent-guinard]

Hi @bcantoni,

Thanks for coming back to us on this issue (and a the other ones we had opened)!

The underlying data is not aware of the desired viz date format.

I can agree on that but in the screenshot we sent the issue is experienced in the Summary Data.

The "DAY()" function has a "date-time" data type whereas the "MDY()" function has an "int" data type, even though the produce the exact same formatted value (a date).

[bcantoni]

Thanks @florent-guinard for the additional feedback; I'll go ahead and reopen this one so we can investigate.