Date format sent to email

[Pain1666]

When email is sent for approval, the start and end date don’t include time, even if the form is modified to have date+time and the google sheets report the time correctly.
Any way to format the date inside the script before it’s sent to the approver email?

thanks

[glucee]

You have to add time in the setting sheet:

"Hello,



This is the automated message from the leave request process.



Your employee {{emailAddress}} has requested leave



FROM: {{timeOffStartDate}}

TO: {{timeOffEndDate}}

TYPE: {{reasonForApplication}}




COMMENTS:

{{additionalInformation}}



<a href=""
{{approval_url}}"">Approve || <a href=""{{deny_url}}"">Deny"