Hello!
I recently created a new layout for my team to create tickets, one of the fields for a type of ticket is a date type field (not a date-time, just date), then I also created a workflow rule that sends out an email alert to a user with the ticket information, including this date field as a placeholder, so the workflow rule gets triggered any time a new ticket is created, all works fine within the ticket, but the email response shows up a different date than the one in the ticket, and this happens to any user who tries to create a ticket with this layout (they may be located on any country around the world)
See the screenshots below for reference:
1. This is the field I am using as an example :
2. This is the email alert template with the placeholder, as you can see, it matches the name on the screenshot above
3. You can also see here the ticket field (which shows 04/11) and that is the right information, while you can also see on the right side of the screen, the email response sent by the workflow rule sent to the internal team member which shows a different date AND it shows time (which is NOT part of the field at all (and should not even show up)
4. Additionally, the same workflow rule mentioned in the description, sends an email to external clients (this is not an email reply, but an email alert) and gets sent to the client and it does show up the right value
So, this only affects the email reply with this type of fields , it ALWAYS shows up as the day before and it puts that weird '08:00 PM' at the end, which is confusing for our team members.
Can anyone help me with this? Why is it always sending a different date on email replies only, and why does it add time if the field is date only?