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?
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).