topic Re: Format timestamp in QlikView

Format timestamp

johnan — Tue, 12 Sep 2023 06:10:31 GMT

Hi, this timestamp: 23.08.2023 11:17:42.000

How to get the date out of it 🙂

Re: Format timestamp

henrikalmen — Tue, 12 Sep 2023 07:04:01 GMT

This should give you date in ISO8601 format: Date(Timestamp#('23.08.2023 11:17:42.000', 'DD.MM.YYYY hh:mm:ss.fff'), 'YYYY-MM-DD')

If you just want the date part as a string you could do: left('23.08.2023 11:17:42.000', 10)

Re: Format timestamp

PrashantSangle — Tue, 12 Sep 2023 10:42:47 GMT

23.08.2023 11:17:42.000

try

Date(Timestamp#('23.08.2023 11:17:42.000','DD.MM.YYYYY hh:mm:ss.fff'))

Re: Format timestamp

Vegar — Tue, 12 Sep 2023 13:03:12 GMT

⚠️ Warning. Be cautioninous when using the formating function date(). It does not convert values into a date value it only formats how the value is displayed.

Take a look at my example below. Notice how I use date() for the field Date_stamp and the function dayname() for DayName_stamp. And that those are displayed identical in the first table. But using a filter pane/listbox you notice that Date_stamps have three "identical" values and DayName_stamp has only one. This is because Date_stamp still holds the three timestamp values, but it only displays them as a date.

I would recommend you to use dayname() or put a floor around the value you put into the date function, like this date(floor(...)) in order to get a date value and not only a date presentation.