Timezone in datetime custom field error

General Discussion
1

Hi all.

All my timezones are set to Europe/Lisbon:

  • mautic system settings
  • mautic profile settings
  • vps host timezone
  • php and fpm .ini files for 8.1
  • hestiacp settings

The problem is that when I send a campaign email including a custom field with datetime from a mautic form, the time is displayed with 1 hour less.

Checking the database (mariaDB) I can see the right date and time.
my mautic version is 5.

Also I have a workflow in n8n that sends this field to Google calendar and it displays the right time.

Any ideas?

4

After several tests i can confirm that:

  • When you send an email including Tokens with Date/Time the passed value is in UTC time format;
  • In Mautic’s interface (dashboard, contact’s profile, etc… you’ll always see the date/time fields correctly in your timezone;

Try to send an email to a Contact from the Contact’s page including tokens like ‘Last activity’, ‘Today’ and a custom field with date/time value. Also note that my time zone is Europe/Lisbon.

I got the ‘Today’ token like 27-04-2024 18:18, which is correct; But the other two date/time values are with 1 hour less. And the format is like:

2024-05-03 09:50:00 <---- Custom date/time field value

2024-04-27 17:18:41 <------ Last activity field value