topic Re: Format of timestamp is wrong in App Development

Format of timestamp is wrong

Broly — Mon, 20 Dec 2021 21:08:46 GMT

Hi all,

I would like to ask for your help with these timestamps:

As you can see when I convert to timestamp MaxLoadTime I get wrong output.

I attached the raw and converted data in the table.

Can someone tell me what did I do wrong?

Thanks

PrashantSangle — Fri, 13 Nov 2020 11:36:01 GMT

when you use max() or min() then qlik convert date into number format.

You have to use timestamp() before max() or min(). like

timestamp(max(datefieldName))

Regards,

Prashant Sangle

Broly — Fri, 13 Nov 2020 13:55:56 GMT

I understand that, but as you can see in the red square

rwunderlich — Fri, 13 Nov 2020 15:01:29 GMT

The date portion of your format mask should be upper case: DD.MM.YYYY. "mm" is minutes.

-Rob