Flowchart 'Update date, set current date + 0 days', sets TOMORROW date

[Russ]

Hey guys, question,

I have a very simple flowchart:

Update Target Record Loan
Last time stage changed
Field: Modified At plus 0 days

or:

Update Target Record Loan
Last time stage changed
now plus 0 days


It always sets up the date to 'Tomorrow', as of now it's Dec 9, it sets up to Dec 10



Please help, timezone set properly,


Version 8.4.2


I even checked database, it literally has "2024-12-10"

cLastTimeStageChanged - type "Date"

[yuri]

Hi Russ,

Maybe consider using a formula expression to convert a datetime value to a date value with honoring the needed timezone.

[item]

Hi,
it's modifiedAt field, so i don't think formula work, Yuri can confirm or not.
For me, you need add another field and let "modifiedAt" EspoCRM compliant

Best Regards

[Russ]

Hi Russ,

Maybe consider using a formula expression to convert a datetime value to a date value with honoring the needed timezone.

Is there a way to make system (Espo) update date properly? It makes 'tomorrow' while it was today. We have only 1 timezone (setup in user preferences and system settings).

Adding formula to override is a 'workaround' that will make other problems down the road, is there a way to fix the issue?

Thank you

[Russ]

Hi,
it's modifiedAt field, so i don't think formula work, Yuri can confirm or not.
For me, you need add another field and let "modifiedAt" EspoCRM compliant

Best Regards

I am not overriding modified at field. I need a new field to have date (now). It was working before and now is not.

Thanks

[yuri]

A formula script in a workflow action is not a workaround but a legit documented solution. I'm not sure why it adds 1 day for your case. It needs investigating, I don't have time right now, it will take some time.

Looking at the code, it seems it should work fine provided your default time zone is correct. I remember I tested this functionality this year.

[yuri]

I tested and it worked fine for me. Do you have a proper time zone set in Administration > Settings > Locale > Time Zone? Is it the same as in the user's preferences?