Forum Discussion

Manasi25's avatar
Manasi25
Icon for Helper II rankHelper II
4 years ago

How to format different time&date zone into EST

I have my data below and i need to format each row into EST date &time zone.   Please advise !    
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Manasi25 Just add 4 hours. or [TIME} + (4 * 1/24)

Manasi25's avatar
Manasi25
Icon for Helper II rankHelper II
4 years ago

Hello Greg

Thank you for response.
I have added hours to this "TIME" col, but due to it's having "text" format , value can not convert.

I changed format to"DATE/TIME" as well, still getting error.

 

  • Manasi25's avatar
    Manasi25
    Icon for Helper II rankHelper II
    4 years ago

    Can't we convert TEXT to Date/Time ?