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