Get new Date
A simple function to get a formatted date instead of a timestamp in Apps Script. Get the timezone of the sheet so a user doesn't have to edit anything other than the timezone of the sheet and apps script.
Apps Script APIs
Methods used
Code.gs