Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
reporting_neu
Creator III
Creator III

Get Max from Timestamp with Timezone

Hello,

I need the maximum date with the latest time. Unfortunately, I can't get that with this format. Can you help?

2023-12-07 12:21:15.532+01:00
2023-12-08 12:28:15.532+01:00
2023-12-07 11:12:15.532+01:00

I would get
2023-12-08 12:28:15.532+01:00

Labels (1)
2 Replies
Chanty4u
MVP
MVP

try this

Max(Timestamp(TimestampField, 'YYYY-MM-DD hh:mm:ss.SSSZ'))

reporting_neu
Creator III
Creator III
Author

Thank you. But unfortunately I don't get any result from the formula 😞