Alert date format is different

Adam Hutchinson

Hi,

 

I have set my date format to dd/mm/yyyy and works fine in my sheets.  However, when an alert is sent it enters my inbox in mm/dd/yyyy format.  Is there anyway to make it consistent?

Kennedy Stomps

Hi Adam-- Apologies for the delay in my response! Can you confirm where in the alert you're seeing the date format change? Is this in the subject line of the alert, or actually within the sheet data included in the alert?

Adam Hutchinson

Hi,

It is within the sheet data included in the alert.

Kennedy Stomps

Hi Adam-- Just to confirm: are you the owner of the sheets that this is happening on? Are you also the user who set up the Notification? If not, does the sheet Owner have the same account settings as you? This information will greatly help with my investigation of this issue!