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!

Oracle DV Desktop - How to change data from text to date in GUI

Received Response
edited Sep 11, 2019 5:22AM in Oracle Analytics 1 comment


How to convert text fields into dates with data that has null or "-" or ""


Hi, I'm new to DV and coming up against some issues with the data set I've imported to a new project.  Using the DV Desktop app - when looking at the table of data and I click on the column header I get some options.  One of those options is to "Convert to Date...".  I then get a popup window and when I try to convert the data I face a number of issues.

1) First issue is that the convert option fails as it can't handle "" or null data fields.


Howdy, Stranger!

Log In

To view full details, sign in.


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