Workflow dates are processed in UTC+0 instead of the user's timezone #5296

New issue

Open

opened 2026-02-20 16:32:33 -05:00 by deekerman · 0 comments

deekerman commented

2026-02-20 16:32:33 -05:00

Owner

Originally created by @SinergiaCRM on GitHub (Jan 27, 2025).

Issue

In Workflows, dates are processed and displayed in UTC+0 rather than respecting the timezone configured in the user's profile. This causes operations involving dates in workflows to not reflect the user's timezone

Possible Fix

No response

Steps to Reproduce the Issue

1. Edit the user's profile and change the timezone to one different from UTC+0, for example, Europe/Madrid.
2. Create a workflow on the Tasks module that triggers "Only on Save" for "All records."
3. In the workflow, add the action "Calculated Fields" with "Subject (P0)" and "Start Date (P1)." Use the following formula:

{P0}: {P1} (Year: {date(Y;{P1})}, Month: {date(m;{P1})}, Day: {date(d;{P1})}, Hour: {date(H;{P1})}, Minutes: {date(i;{P1})}, Seconds: {date(s;{P1})})

4. Save a Task with a "Start Date" and verify that the description is populated with the date in UTC+0 instead of the user's timezone.

Context

No response

Version

7.14.6

What browser are you currently using?

Chrome

Browser Version

No response

Environment Information

PHP 8.2

Operating System and Version

Ubuntu 23.10

Originally created by @SinergiaCRM on GitHub (Jan 27, 2025). ### Issue In Workflows, dates are processed and displayed in UTC+0 rather than respecting the timezone configured in the user's profile. This causes operations involving dates in workflows to not reflect the user's timezone ### Possible Fix _No response_ ### Steps to Reproduce the Issue ```bash 1. Edit the user's profile and change the timezone to one different from UTC+0, for example, Europe/Madrid. 2. Create a workflow on the Tasks module that triggers "Only on Save" for "All records." 3. In the workflow, add the action "Calculated Fields" with "Subject (P0)" and "Start Date (P1)." Use the following formula: {P0}: {P1} (Year: {date(Y;{P1})}, Month: {date(m;{P1})}, Day: {date(d;{P1})}, Hour: {date(H;{P1})}, Minutes: {date(i;{P1})}, Seconds: {date(s;{P1})}) 4. Save a Task with a "Start Date" and verify that the description is populated with the date in UTC+0 instead of the user's timezone. ``` ### Context _No response_ ### Version 7.14.6 ### What browser are you currently using? Chrome ### Browser Version _No response_ ### Environment Information PHP 8.2 ### Operating System and Version Ubuntu 23.10