Free Trial

Alteryx Designer Desktop Discussions

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

Date TimeZone issue

clarrock
8 - Asteroid

Hi Team, 

 

How do I make sure that my datetimetoday() formula follows IST timezone always when running?

 

Thanks

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @clarrock ,

 

There is no way to get IST directly. What you can do is add or subtract on datetimenow then get the day.

 

If you tell which is your timezone (system timezone) i can help you out.

ImadZidan
12 - Quasar

Hello @clarrock ,

 

I agree with @atcodedog05 . if your local time setting is IST you can use DateTimetoLocal(dt) function. Otherwise, try the below function

 

Datetimeadd(DateTimeToUTC(DateTimeNow()),4,'hours')

 

I hope this helps

atcodedog05
22 - Nova
22 - Nova

Hi @clarrock ,

 

I just figured it out.

atcodedog05_0-1600798698224.png

Get the UTC time and +5hrs 30 mins to get always get IST.

 

Workflow is attached.

 

Please check let me know.

clarrock
8 - Asteroid

@ImadZidan Thanks, this is solve

atcodedog05
22 - Nova
22 - Nova

Hi @clarrock ,

 

This should actually work because UTC(Universal Time) time is independent of time zone.

 

And IST is UTC + 5hr 30 mins

Labels
Top Solution Authors