Date Formula output in gallery is different from designer desktop

Question

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

patrick_digan · Accepted Answer

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