Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible to format this timestamp to format DD.MM.YYYY?
Jan 4, 2018 2:28:58 PM
Target: 04.01.2018
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')
You can use Date function (as long as the date is interpreted as $date, $timestamp)
Date(fieldname, 'DD.MM.YYYY')
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')
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')
Thanks
Date(Floor(TimeStamp#(TimeStampField, 'MMM D, YYYY h:mm:ss TT')), 'DD.MM.YYYY')
worked