Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I am loading data from excel and getting below result. Can anyone please help here to convert it to date. Attaching the excel file as well.
Looks like the null records are not reading as Date format. Perhaps this?
Alt(Date(Date#(TransactionDate, 'DD/MM/YYYY')), Date(TransactionDate)) as TransactionDate
May be?
Date(Date#(TransactionDate,'DD/MM/YYYY'))
It gives below result.
Looks like the null records are not reading as Date format. Perhaps this?
Alt(Date(Date#(TransactionDate, 'DD/MM/YYYY')), Date(TransactionDate)) as TransactionDate
I had a quick look at your data and added 1 to the next column and found the below. Your data seems to be in DD/MM/YYYY AND DD-MM-YYYY format.
Try the below
Alt(Date(date#([Transaction Date],'DD/MM/YYYY'),'DD/MM/YYYY'), Date(date#([Transaction Date],'DD-MM-YYYY'),'DD/MM/YYYY'))
OR
Date(date#(PURGECHAR(TEXT([Transaction Date]),'/-'),'DDMMYYYY'),'DD/MM/YYYY')