I've been using this script I adjusted from a previous question

To:

Note:

• From your question, I used MM/dd/yy as the date format. If you want to modify this to dd/MM/yy, please modify it.

Reference:

• 

  Reference:

  • https://webapps.stackexchange.com/questions/73701/conversion-from-object-to-string-in-google-apps-script