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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Business Objects Help - Date Field Errors

edited Feb 20, 2013 2:17PM in Taleo Enterprise

Content

We have a Date UDF, which when reported on in BO does not register as a date datatype and displays in the MM-dd-yyyy format.

My problem is that I want to perform some date calculations on this field (DaysBetween) Because this has been pulled through as straight text, I am having no luck.

Whenever I apply the "todate" function on this date, I receive an ERROR in the cell, I have even tried "to Number" but get the same results. I am assuming it is because the seperator on the dates being pulled is "-" as opposed to "/" Any ideas out there?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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