Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Just attached the Date file in Excel. I tried the below suggestions, but no luck.
Hi, I have below data in Excel, the default format is not date. I would like to keep only the date and change the format to MM/DD/YYYY after loading into Qlik. I tried date(floor(date#(Date,'M/D/YYYY h:mm')),'MM/DD/YYYY'), but no luck.
Any suggestions? Thanks!
PS, in Excel it actually is 9/30/2015 12:00:00 AM, but displayed as 9/30/2015 0:00
Date
6/30/2015 0:00 |
7/31/2015 0:00 |
8/31/2015 0:00 |
9/30/2015 0:00 |
10/31/2015 0:00 |
11/30/2015 0:00 |
12/31/2015 0:00 |
Hi Ze Li,
Maybe try,
Date(SubField(Data,' ',1),'MM/DD/YYYY')