Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convertion of diff date format in to unique format

Hi All,

I have date field in the attached excel. it is in DD-MM-YYYY and in string format. i need to convert everything in to DD-MM-YYYY format.

For Instance in the attached excel i have 01-08-2013, 01-09-2013 and some string dates like 15/01/2013 , 16/01/2013 but all are belongs to january month.

Expected result is 08-01-2013, 09-01-2013, 15-01-2013, 16-01-2013

Kindly help me to resolve this.

Thanks in Advance.

Mahi.

10 Replies
manideep78
Partner - Specialist
Partner - Specialist

LOAD    date(Alt(Date#(A,'DD/MM/YYYY'),Date#(A,'DD-MM-YYYY'),Date#(A,'MM-DD-YYYY'),Date#(A,'MM/DD/YYYY'))) as A,

     B

FROM

C:\Users\Manideep\Downloads\date.xlsx

(ooxml, no labels, table is Sheet1);