Conversion of TimeStamp to date

[Purushothaman]

Hi There,

How to convert a time stamp to date in Qlik Sense data load editor?

13/2/2014 12:00:00 am

Anyone please help.

Thank you!

[Or · Accepted solution]

If the field is recognized as a timestamp, you can use dayname(Field) or date(floor(Field)).

If it is not, use TimeStamp#(Field,format) to force Qlik to parse it as a timestamp and then use the above functions as required.

[Purushothaman]

date(floor(Field)) is working. Thanks for the help.