Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have data loaded as NUM. It contains date. I want to convert it to date format so that I can load it into the datepicker.
Here is my data:-
I have tried these in the data load editor:-
Load
Date((Floor(Timestamp#([stamp], 'YYYY-MM-DD hh:mm:ss') ))) AS [amidate];
Date((Floor(Num#([stamp], 'YYYY-MM-DD hh:mm:ss') ))) AS [amidate];
I have set my date and time to this:
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
It still loads as Num. Can anyone suggest how to load it in Date?
Try this,
Date(Floor([stamp])) AS [amidate];
Tried. It still loads as Numeric.
The field stamp is loaded from the source in this format 2022-05-18 01:00:00. When I see it on qlik it is in this format:-
Your field isn't numeric else a string and the string-content is neither a date nor a time else a timestamp. This means you need to adjust the timestamp-variable to be able to interpret the content as timestamp which could be then transformed into a date like mentioned above with floor().
- Marcus