Epoch time to Your time zone

Question

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 Answer

Hey @AKPWZ,

You only need to convert GMT to your time. Therefore

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