Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
balrammahato204
Creator
Creator

Convert Multiple Timezone to Single TimeZone

Hi All,

Could you please help me on below scenario. 

On My data set I have Multiple time Zones timestamps and wanted to Convert Into Single EST Time zone  timestamp.

I have tried with ConvertToLocalTime() Function but its take the system time zone and convert to the chosen timezone. 

ConvertToLocalTime('04/04/2023 12:00:00','London') not able to find the output like below.

Example:

Timestamp Time Zone Converted EST Timestamp  
04/04/2023 12:00:00 SST ? Wanted in EST
04/04/2023 12:00:00 CET ? Wanted in EST
04/04/2023 12:00:00 IST ? Wanted in EST
       

 

Thanks in Advance

Balram

Labels (2)
1 Reply
sandeep-singh
Creator II
Creator II

Try this:

Set vTimezone = 'Eastern Time (US & Canada)';

Let vTimeStamp = Date(ConvertToLocalTime(UTC(), '$(vTimezone )'), 'MM/DD/YYYY h:mm:ss TT');