
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Convert CET time to UTC Time
Good morning fellow Qlik users.
I receive data that includes a Timestamp detailing CET time, with an additional column showing the time difference to UTC
Entry Date | Entry Date TZ |
2024-01-30 09:34:30 | +01:00 |
I want to be able to display the time as UTC which would show the correct time in the UK by utilizing the TZ column as this changes between 1 or 2 hours depending on the time of year.
I'd be most grateful if someone could provide some guidance on how to do this.
Many thanks,
David
- Subscribe by Topic:
-
Data Load Editor
-
expression
-
General Question
-
Qlik Sense
-
Script
-
Set Analysis

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @David_K ,
Just do the following :
Timestamp(num(Entry Date) - num(Entry Date TZ)) as GMT timestamp
I think this should work.
Regards,
Rohan.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @David_K,
Check this one:
Timestamp(
[Entry Date] - (Interval#([Entry Date TZ], 'hh:mm') * Interval#('60', 'mm'))
) as [Entry Date UTC]
Or
UTC = Entry Date - (Interval#([Entry Date TZ], 'hh:mm') * Interval#('60', 'mm'))
