I want to reload time GMT timezone to EST timezone

[Vinni2000]

I want convert timestamp GMT timezone to EST timezone timestamp , timestamp format  5/8/2023 12:32:08PM GMT

[hic · Accepted solution]

Use ConvertToLocalTime().

The script below first interprets the original timestamp, then converts it and formats it to US format.

Load

Timestamp(ConvertToLocalTime(Interpreted , 'EST'),'M/D/YYYY hh:mm:ssTT') as Converted,

*;

Load 

Timestamp#(Left(Timestamp,Index(Timestamp,' ',2)-1),'D/M/YYYY hh:mm:ssTT') as Interpreted,

Timestamp

Inline

[Timestamp

5/8/2023 12:32:08PM GMT

5/9/2023 02:32:08PM GMT];

[Vinni2000]

I am not getting answer , i stored timestamp in variable when i use that variable in converttolocatime function getting error like variable not exists 

[hic · Accepted solution]

You need to first strip the 'GMT' away, e.g.  
Left(TimestampVariable,Index(TimestampVariable,' ',2)-1)

Then interpret it using Timestamp#():  
Timestamp#(<TheAboveExpression>,'D/M/YYYY hh:mm:ssTT')

Then you can use ConvertToLocalTime().