Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Broly
Contributor III
Contributor III

Format of timestamp is wrong

Hi all,

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

Broly_0-1605259774545.png

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

 

Labels (1)
1 Solution

Accepted Solutions
rwunderlich

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

-Rob

View solution in original post

3 Replies
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

Great dreamer's dreams never fulfilled, they are always transcended.
Broly
Contributor III
Contributor III
Author

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

Broly_0-1605275737030.png

 

rwunderlich

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

-Rob

View solution in original post