Hello, I have a script that reads a value from a date in a cell and sends an email when the date has expired.
It's all working, except that although the date is formatted in BR, that is dd/mm/aaaa , when I get the alert email, it comes in the format: mm/dd/aaaa .
Does anyone have a tip? Thankful. The following is the code snippet:
var message = dataRange[i][3] + "<P> *Esta é a Proposta de encaminhamento do dia " + dataRange[i][2] + "\n" + ", que deve ser respondida até a data de " + dataRange[i][4] + "<HTML><BODY>" + '<i><font size=1> Unidade auditada. </font></i></A>.' + "</HTML></BODY>"; MailApp.sendEmail(emailAddress, subject, "", {htmlBody: message});