Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am loading from script
LOAD
SnapshotDate,
date(SnapshotDate,'M/D/YYYYY') as Snapshot1
FROM [lib://ASUX QDF/99.Shared_Folders/2.QVD/1.Extract/PV_HistHeadcount.qvd]
(qvd);
and when I then look on the result I see:
I have expected in Snapshot1 to have only one time 2/1/2023. Above is showing two different tables. Also when I add this on a line chart I can see the snapshot date more then one time. What to do?
Best regards
Pia
Try
date(Floor(SnapshotDate),'M/D/YYYYY')
The Date() function does not remove the time part - it just formats it. But the Floor() rounds to integers.
See also
https://community.qlik.com/t5/Design/Get-the-Dates-Right/ba-p/1476178
https://community.qlik.com/t5/Design/Why-don-t-my-dates-work/ba-p/1465849
Try
date(Floor(SnapshotDate),'M/D/YYYYY')
The Date() function does not remove the time part - it just formats it. But the Floor() rounds to integers.
See also
https://community.qlik.com/t5/Design/Get-the-Dates-Right/ba-p/1476178
https://community.qlik.com/t5/Design/Why-don-t-my-dates-work/ba-p/1465849