Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Data import in MON-YY format - has to be stored as text - how can it be converted in report — Cloud Customer Connect
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

Data import in MON-YY format - has to be stored as text - how can it be converted in report

Received Response
23
Views
1
Comments
edited May 29, 2019 7:48PM in Reporting & Analytics for B2C Service 1 comment

Summary

I have issues with converting a text field to a date field in format MON-YY

Content

I have a file I need to manually import and it has a date value in the MON-YY format.  It's going into a custom object so I had to make that a text field since it was not actually in date format and had that - in it.  But when I get it into a report, I was trying to convert that to a date so I could sort on it.  But it's not letting me do a MON-YY format on the date in a to_date function.  What am I doing wrong?  Or is this just not possible?  

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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