Convert Multiple Timezone to Single TimeZone

[balrammahato204]

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

[sandeep-singh]

Try this:

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

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