Convert CET time to UTC Time

[David_K]

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

[Rohan]

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.

[TauseefKhan]

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'))