Hello ,
i have simple workflow here . In Clickup a trigger starts this workflow. He is getting the Task and extracting the value ands sends to Airtable. But there is a error with the date.
The result is 2025-06-26 which is today. But the output is yesterday.
I tried different kind of formatting but nothings works so far.
It’s probably a timezone/locale issue. Try and find out what the timezone on clickup vs your instance is. For example I live in GMT +02:00, which means when I have two dates without timestamps, they are technically midnight 2025/06/26 00:00:00, but in american UCT time it will be 2025/06/25 22:00:00, which is 2 hours different causing the date to display “yesterday”.
You can force the workflow’s timezone by going to the settings in the top right 3 dot menu and changing it to your timezone to compensate
I have tried different settings on the host but nothing worked correctly until i found out the clickup is always returning in UTC. So my function was converting UTC into ISO. That was the error. Thank you for your help