How to convert Numeric to date in data load editor

[tanmayNobel]

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?

[tamilarasu]

Try this,

Date(Floor([stamp])) AS [amidate];

[tanmayNobel]

Tried. It still loads as Numeric.

Data Load script

[tanmayNobel]

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:- 

[marcus_sommer]

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