ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Epoch time to Your time zone

AKPWZ
8 - Asteroid

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!

AKPWZ_0-1684987853264.png

 

2 REPLIES 2
FrederikE
13 - Pulsar

Hey @AKPWZ,

 

You only need to convert GMT to your time. Therefore

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

FrederikE_0-1685010152537.png

 

AKPWZ
8 - Asteroid

Thats awesome @FrederikE thank you so much!

Labels
Top Solution Authors