Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Date Formula output in gallery is different from designer desktop

KEPM23
7 - Meteor

Hello Guys!

 

My issue is that i have a date formula (see below) that is working fine when i run in designer desktop but when run in the gallery the date is delayed with 1 day.

 

Formula: DateTimeFormat((DateTimeAdd (DateTimeToday(), -1,"days")),"%m-%d-%Y")

 

Actual Date: 07/08/2020

Expected Date Output: 07/07/2020

Output in Desktop Designer Alteryx Run: 07/07/2020

Output in Gallery Run: 07/06/2020

 

I am using the same timezone to my alteryx gallery profile that i have in my Laptop which is Asia/MNL (+08:00).

 

Thanks,

Kris

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor

Hi @KEPM23 


Actually, it depends on which time zone your worker node is processing this workflow.

 

First we need to understand how your server is setup. Is it a single node? Are all the server machines in the same time zone?


Cheers,

patrick_digan
17 - Castor
17 - Castor

@KEPM23 I would try a formula tool with DateTimeNow() and run it on the server so you can see what time the server is reporting.