Format Timestamp

[madmax88]

Hi,

Is it possible to format this timestamp to format DD.MM.YYYY?

Jan 4, 2018 2:28:58 PM

Target: 04.01.2018

[DavidM]

You can use Date function (as long as the date is interpreted as $date, $timestamp)

Date(fieldname, 'DD.MM.YYYY')

[tresesco]

In qlik date() is a formatting function. If you have a timestamp, you could just try like:

Date(<yourtimestamp>, '<yourformat>')

i.e. 

Date(<timestamp>, 'DD.MM.YYYY')

[sunny_talwar · Accepted solution]

You can try this if it is read as a timestamp by Qlik

Date(Floor(TimeStampField), 'DD.MM.YYYY')

If not read as a timestamp

Date(Floor(TimeStamp#(TimeStampField, 'MMM D, YYYY h:mm:ss TT')), 'DD.MM.YYYY')

[madmax88]

Thanks

Date(Floor(TimeStamp#(TimeStampField, 'MMM D, YYYY h:mm:ss TT')), 'DD.MM.YYYY')

worked