Convert String value to Date

Logeshwar

We convert String " 29692" to Date "16-04-1981" using " =Value() " formula in excel. How can we convert the same string to Date in Dataiku

Turribeach

Excel stores dates starting with 1 for 01-Jan-1900 so you all need to do get a proper date from the Excel number is add it to 01-Jan-1900. Use this formula in a Prepare recipe:

inc(asDate('01-Jan-1900', 'dd-MMM-yyyy'), 29692, 'days')

https://doc.dataiku.com/dss/12/formula/index.html#date-functions

Logeshwar

Thank you