Notion FormulasFunction Index
Date and time functions
Date functions such as today, now, dateAdd, dateBetween, formatDate, and parseDate.
Date and time
| Function | Purpose | Return value or alternative |
|---|---|---|
now() | Current date and time | Date |
today() | Current date | Date |
minute() | Minute | Number |
hour() | Hour | Number |
day() | Day of the week, 1 = Monday and 7 = Sunday | Number |
date() | Day of the month | Number |
week() | ISO week number | Number |
month() | Month | Number |
year() | Year | Number |
dateAdd() | Add time | Date |
dateSubtract() | Subtract time | Date |
dateBetween() | Difference between two dates | Number |
dateRange() | Create a date range | Date range |
dateStart() | Start time of a date range | Date |
dateEnd() | End time of a date range | Date |
timestamp() | Convert to a Unix millisecond timestamp | Number |
fromTimestamp() | Convert a millisecond timestamp to a date | Date |
formatDate() | Format a date | Text |
parseDate() | Parse ISO 8601 date text | Date |
To use these formulas directly in task reminders, project progress, note heatmaps, and reports, continue with FLO.W Notion Template.
Last updated on