Get today date in Google Apps Script

by 
Utilities.formatDate(new Date(), "GMT+1", "dd/MM/yyyy")

You can change the format by doing swapping the values.

  • dd = day(31)
  • MM = Month(12) – Case sensitive
  • yyyy = Year(2017)
function changeDate() {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(GA_CONFIG);
    // You could use now Date(); on its own but it will not look nice.
    var date = Utilities.formatDate(new Date(), "GMT+1", "dd/MM/yyyy")
    var endDate = date
}

More Related Contents:

  1. What are valid Date Time Strings in JavaScript?
  2. How do you display JavaScript datetime in 12 hour AM/PM format?
  3. Incrementing a date in JavaScript
  4. Check time difference in Javascript
  5. Why does the month argument range from 0 to 11 in JavaScript’s Date constructor?
  6. Browsers, time zones, Chrome 67 Error (historic timezone changes)
  7. Javascript – get array of dates between 2 dates
  8. Compare two dates with JavaScript
  9. new Date() is working in Chrome but not Firefox
  10. How to parse a time into a Date object from user input in JavaScript?
  11. How to get the difference of two dates in mm-dd-hh format in Javascript
  12. Javascript format date / time [duplicate]
  13. javascript Date timezone issue
  14. How to JSON stringify a javascript Date and preserve timezone
  15. Convert normal date to unix timestamp
  16. How do I specify the time zone when creating a JavaScript Date?
  17. Get current date in DD-Mon-YYY format in JavaScript/Jquery
  18. Stop javascript Date function from changing timezone offset
  19. Why isn’t “2016-02-16” equal to “2016-02-16 00:00”?
  20. from unix timestamp to datetime
  21. Convert string to datetime
  22. Work with a time span in Javascript
  23. How to Convert Persian (Jalali) Dates to other 18 Calendar Dates in Javascript without External Libraries or Complex Astronomical Equations
  24. Date.toISOString() but local time instead of UTC
  25. create javascript date UTC
  26. Round a timestamp to the nearest date
  27. How to display a Date object in a specific format using JavaScript?
  28. JavaScript – Get system short date format
  29. Converting Google spreadsheet date into a JS Date object?
  30. How to sort an object array by date property?

Leave a Comment