Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Convert text field to date to use for calculation — 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

Convert text field to date to use for calculation

Accepted answer
106
Views
3
Comments
edited Apr 9, 2015 8:28PM in General Transactional Reporting (OTBI) 3 comments

Content

We have a UDF field which is populated by the candidate on the recruiting side in a form.  The input is a DATE. There is no other choice on how to bring in the date and comes over as TEXT into OBIEE in the candidate UDF.   Like this --->>>  04-06-2015   I cannot use this to perform calculations with other dates for aging.  How can I convert a text field to date?  I found this but it did not work....

http://obieetutorialguide.blogspot.com/2013/01/to-get-age-between-two-days-in-obiee.html   

http://www.bravesoft.com/blog/?p=682

Also, what is the formula to do aging between 2 dates in OBIEE?  I want to calculate the number of days between 2 dates in the report.  Example: "current_date" and "consent_date"  (how many days in between)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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