Epoch time to Your time zone

[AKPWZ]

Hi, 

The problem I'm facing right now is this:

When I'm converting epoch time into DateTime using this formula "DateTimeAdd('1970-01-01',[date]/1000, 'Seconds')" I'm getting the GMT value (marked yellow), but in actual I need "Your TIme Zone" value (marked blue).

Can you please help me to solve this issue. Thank you!

[FrederikE · Accepted solution]

Hey @AKPWZ,

You only need to convert GMT to your time. Therefore

DateTimeAdd([DateTime],5.5*60,'minutes') should do it. 

[AKPWZ]

Thats awesome @FrederikE thank you so much!