Dealing with date formats in QlikSense

[Adil-Haider]

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.

[Anil_Babu_Samineni]

May be?

Date(Date#(TransactionDate,'DD/MM/YYYY'))

[Adil-Haider]

It gives below result.

[Anil_Babu_Samineni · Accepted solution]

Looks like the null records are not reading as Date format. Perhaps this?

Alt(Date(Date#(TransactionDate, 'DD/MM/YYYY')), Date(TransactionDate)) as TransactionDate

[Adil-Haider]

Thanks..it works!!!!

[pradosh_thakur]

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')