How to show the Birth Date at format MM/DD/YYYY?

[Alexsander Siqueira]

Hello guys!

I have a google form from which I extract a database. Among the entries, I collect the date of birth. From that database, I generate a formatted PDF file. It happens that when I transfer the date of birth to the docs or pdf, the date of birth is not in the MM/DD/YYYY format, as shown in the spreadsheet and form. The date of birth is shown like this: "Tue Feb 20 1977 00:00:00 GMT-0300 (Brasilia Standard Time)".

Code:
body.replaceText('{{birthdate}}', row[54]);

The row 54 shows the birth date entries.

How can I make the date show in MM/DD/YYYY format using this code?

Thanks!

[Bennett, Scott]

You can try

Utilities.formatDate(birthdate, //Timezone you want as string ,'MM/dd/yyyy')

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/b48b44ad-389a-48ab-922c-1f732cf0e27fn%40googlegroups.com.

--

Scott Bennett

Data and Assessment Coordinator/Math Teacher

Bradley-Bourbonnais Community High School

P 815.937.3707 ext. 6010

[Marco]

Use Utilities.formatDate(yourDate, 'GMT', 'MM/dd/yyyy')

Marco Pires Núcleo de Tecnologia da Educação - NTE Gabinete Superintendência Regional de Ensino - Diamantina Praça das Missões, 45 Largo Dom João TEL: (38) 3532-6265

--

You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/b48b44ad-389a-48ab-922c-1f732cf0e27fn%40googlegroups.com.

PRESERVE A NATUREZA, EVITE O DESPERDÍCIO DE PAPEL E PENSE ANTES DE IMPRIMIR.

"Responsabilidade com o MEIO AMBIENTE"

Esta mensagem e quaisquer arquivos em anexo podem conter informações confidenciais e/ou privilegiadas. Se você não for o destinatário ou a pessoa autorizada a receber esta mensagem, por favor não leia, copie, repasse, imprima, guarde, nem tome qualquer ação baseada nestas informações. Por favor notifique o remetente imediatamente por e-mail e apague a mensagem permanentemente. Este ambiente está sendo monitorado para evitar o uso indevido de nossos sistemas.