topic Re: Date Formula output in gallery is different from designer desktop in Alteryx Server Discussions

Date Formula output in gallery is different from designer desktop

KEPM23 — Fri, 14 Jun 2024 14:50:48 GMT

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

Re: Date Formula output in gallery is different from designer desktop

Thableaus — Tue, 07 Jul 2020 20:04:36 GMT

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,

Re: Date Formula output in gallery is different from designer desktop

patrick_digan — Wed, 08 Jul 2020 02:13:08 GMT

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