Formats a date using a pattern and time zone.
class Utilities method .formatDate()
Utilities is the Apps Script service.
.formatDate() is the method name you will see after a dot in your code.
What it does
Why it's used
- Turn a JavaScript date into a readable string for emails or cells.
- Match a consistent date format across exports.
Common errors
- Forgetting parentheses on formatDate. Write Utilities.formatDate(), not Utilities.formatDate or formatDate by itself.
- Skipping dots between chained calls. Each step needs a dot, like Utilities.formatDate().
- Adding spaces where they do not belong. Write Utilities.formatDate(), not Utilities .formatDate(), Utilities.formatDate (), or Utilities . formatDate().
- Wrong capitalization. Use Utilities and formatDate, not utilities or formatdate.
3 Snippets using this methods
Explore
Related methods
-
.jsonStringify()
Converts a JavaScript object into a JSON string.
-
.jsonParse()
Parses a JSON string into a JavaScript object.
-
.base64Encode()
Encodes a string or bytes as Base64.
-
.parseCsv()
Parses CSV text into a 2D array of values.
-
.base64Decode()
Decodes a Base64 string back into raw data.
More Apps Script
3 Better Sheets tutorials
Add NPS to Your Google Site
Americano Tournament Template With Four Automations
Automatically Backup a Spreadsheet
Related blog posts
Written guides about Utilities.formatDate().
What's Better Than Google Sheets?
Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.
Read post →How to Send Google Forms Entries Automatically with Apps Script
Google Forms provides basic email notifications for form submissions, but enhancing these notifications with detailed summaries can significantly improve productivity and response management.
Read post →Explore Coding in Google Sheets
Did you know you can actually code in Google Sheets?
Read post →