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

Converting to date

in Reporting and Analytics for HCM 2 comments

Summary:

We have hire date and we are using this to create a two new columns called 'Current Year Anniversary Date' and 'Days to Anniversary Date'. It used to work earlier; however, it has stopped working.
When we convert the two new columns to date using the CAST function in OTBI, it gives us an error.
ERROR: Oracle Error code: 1839, message: ORA-01839: date not valid for month specified at OCI call OCIStmtFetch. (HY000)

Tried a few different things, but keep getting stuck at the CAST Function.

Code Snippet (add any code snippets that support your topic, if applicable):
Here is the logic:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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