Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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'))