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.
RÉSOLU

Epoch time to Your time zone

AKPWZ
Astéroïde

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 RÉPONSES 2
FrederikE
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
Astéroïde

Thats awesome @FrederikE thank you so much!

Étiquettes
Auteurs des meilleures solutions