Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
Max(Timestamp(TimestampField, 'YYYY-MM-DD hh:mm:ss.SSSZ'))
Thank you. But unfortunately I don't get any result from the formula 😞