Format of timestamp is wrong

[Broly]

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]

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]

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

[rwunderlich · Accepted solution]

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

-Rob