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