convert to date

[Anonymous]

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

[tamilarasu · Accepted solution]

Hi Ze Li,

Maybe try,

Date(SubField(Data,' ',1),'MM/DD/YYYY')