Date Formula output in gallery is different from designer desktop

[KEPM23]

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

[Thableaus]

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 · Accepted solution]

@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.