Format today's date being exported to Google Sheets

Ask the community
,
1

I have a hidden date picker (ID: todaysDate) on my form so that when a user clicks the submit button (btnSaveForm), their form information along with today’s date is parsed into a Google Sheet. However, the formatting is off when it gets to the sheet, it looks like this “2019-09-16T04:00:00.000Z” - How would you recommend setting this up so that I get a simple mm/dd/yyyy into my Google Sheet? Would it be something like this:

export function todaysDate_onLoad(event) { 
//Code that I'm not sure of
}
2

https://support.wix.com/en/article/corvid-formatting-dates#targetText=Your%20code%20should%20look%20like%20the%20image%20below.&targetText=In%20this%20example,%20the%20date,available%20JavaScript%20date%20options%20here.

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/toLocaleDateString
https://www.w3schools.com/jsref/jsref_tolocaledatestring.asp

3

Were you able to get this to work? I am running into the same issue but wasn’t positive on how to apply the recommended links.