Workflow Send email using Email Template Still Sending Wrong Date Format

cherub-chum · 13 June 2023 17:57

I have seen on the forum and this issue has been lurking around since 2018. Date Field set in email template and when Email is sent it is in YYYY-MM-DD. Although user Preference and System local is set to d/m/Y, the emails sent via workflow have the default DB format. checked system timezone for php and its set to London, which has date format as ‘d/m/Y’ so that should not be a problem too.

There is a PR for date format fix but it hasn’t been updated to merge into core for fixing the issue.

github.com/salesagility/SuiteCRM

Fix #5814 Email template date handling

salesagility:hotfix ← clemente-raposo:fix/email-template-date-handling

opened 10:58AM - 08 Dec 21 UTC

clemente-raposo

+529 -89

## Description - Fix issue: https://github.com/salesagility/SuiteCRM/is…sues/5814 - Apply user formatting to date and datetime on pdf templates ## Motivation and Context - Fix issue: https://github.com/salesagility/SuiteCRM/issues/5814 - Apply user formatting to date and datetime on pdf templates ## How To Test This - See steps to reproduce in: https://github.com/salesagility/SuiteCRM/issues/5814 ## Types of changes - [x] Bug fix (non-breaking change which fixes an issue) - [ ] New feature (non-breaking change which adds functionality) - [ ] Breaking change (fix or feature that would cause existing functionality to change) ### Final checklist - [x] My code follows the code style of this project found [here](https://docs.suitecrm.com/community/contributing-code/coding-standards/). - [ ] My change requires a change to the documentation. - [x] I have read the [**How to Contribute**](https://docs.suitecrm.com/community/contributing-code/) guidelines.

Rascott · 23 October 2023 11:19

I have the same problem in v. 7.13.0

As a temporary solution I do this Workflow through the scheduler or planner and the date and time in the email it sends works correctly.

If, however, the workflow is activated when saving, the date and time is the one set in the database and UTC format.