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 |
