Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
Loading and Retrieve Dates in Correct Format
SummaryLoading Dates formatted as mm/dd/yyyy type but they retrieve in scientific notation
The outline has the date type enabled.
The date fields that are loaded are tagged as date types.
Information loads correctly and I have confirmed the load file (.csv) has the dates formatted as mm/dd/yyyy.
When I go to retrieve (using the Dodeca Add-In), the dates retrieve in scientific notation (1.XXE+09) instead of mm/dd/yyyy.
Has anyone else encountered this problem and know a fix?