Ben SmithBen Smith
Ben Smith/
formatDate
formatDate
formatDate

formatDate

Category
Dates
Accepts
Date
Returns
String
Alternative
More
The format string can contain the following text to represent parts of the date: "YYYY" for year, "MM" for month, "DD" for day, "HH" for hour, "mm" for minute.
Examples Used In
Filter by Formatted Date
Filter by Formatted Date
Found Example Alternatives
Found Example Alternatives
Last Edited Today
Last Edited Today
Products & Materials
Products & Materials
Project Period
Project Period
Last Edited
Last Edited
Filter by Date
Filter by Date
Date is Empty or Today
Date is Empty or Today
Weekly Dates
Weekly Dates
Date Range Formula
Date Range Formula
This/Next Week
This/Next Week
Last/This/Next Week
Last/This/Next Week
🔁
Recurring Dates
Daily Entries
Daily Entries
Relative Dates
Relative Dates
Past/Today
Past/Today
Deadline Status
Deadline Status
Unique IDs
Unique IDs
Days Ago/Left/Away
Days Ago/Left/Away
Count Business Days
Count Business Days
Yesterday/Today/Next
Yesterday/Today/Next
Baking
Baking
🤷
Everyday Problems
Next Month by Weeks
Next Month by Weeks
Time Check
Time Check
Date Range Formatting
Date Range Formatting
Due Date Statuses
Due Date Statuses
Weekly Filtering
Weekly Filtering
Due Date
Due Date
Today/Tomorrow in Range
Today/Tomorrow in Range
Days Working
Days Working
Recur Every D/W/M/Q/Y
Recur Every D/W/M/Q/Y
Birthdays
Birthdays
High School Attendance
High School Attendance
Life Progress
Life Progress
This Week *
This Week *
On This Day
On This Day
Franklin Covey
Franklin Covey
Countdown
Countdown
Last Day of Month
Last Day of Month
Notes & Tags
Notes & Tags
Star Signs
Star Signs
Due State
Due State
Due In
Due In
Syn Count
Syn Count
Date Tests
Date Tests
Contains Current Day or Date
Contains Current Day or Date
On This Day
On This Day
Due Date Status
Due Date Status
Week Range
Week Range
Course Date Progress
Course Date Progress
Date & Time Status
Date & Time Status
This Week
This Week
Priority Level
Priority Level
This Year’s Transactions
This Year’s Transactions
Total of Date Numbers
Total of Date Numbers
Date in Previous Month
Date in Previous Month
Quick Fix for formatDate Escaping
Quick Fix for formatDate Escaping
Even Numbers
Even Numbers
Project Status
Project Status
Formula Formatting
Formula Formatting
What day is it?
What day is it?
Birthday from Day & Month
Birthday from Day & Month
Templates Used In
Recipe Book
Recipe Book
Common Uses
New in 2.0
Share Link
https://notion.cool/formulas/formatDate
Companion Docs
https://www.bensomething.com/notion/formulas/functions/formatdate
 
Syntax
formatDate(date, format, timezone?)
date.formatDate(format, timezone?)
Examples
formatDate(now(), "MMMM D, Y")
now().formatDate("h:mm A", "UTC+1")
 
 
More Info
formatDate · Notion Formulas · Ben Smith
Formats the date using a custom format string.
formatDate · Notion Formulas · Ben SmithformatDate · Notion Formulas · Ben Smith
https://www.bensomething.com/notion/formulas/functions/formatdate
formatDate · Notion Formulas · Ben SmithformatDate · Notion Formulas · Ben Smith