Different dates are reflected in the sheet and in the automated email.

Different dates are reflected in the sheet and in the automated email. I have created a rule saying when a new row entry is made in the sheet the date of request column should take the current date( today's date with a time stamp) and an automated email must be sent to xxx person with few details of the request submitted.

I am able to see the correct date of request in the sheet whereas the automated email sent has previous day's date & time stamp. what could be the issue?

eg:

Form submitted today (1/11/2022)

Sheet captured today's date correctly. (1/11/2022)

Automated email sent has yesterday's date (31/10/2022).

Answers