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

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

Accepted answer
edited Sep 11, 2019 5:18AM in Oracle Analytics 3 comments


Loading 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?

Howdy, Stranger!

Log In

To view full details, sign in.


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