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

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!