Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME 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 😞