now() |
Returns the current date and time. |
now() |
Returns the current date and time. |
dateAdd() |
Adds a specified time period to a date. |
dateAdd(now(), 7, "days") |
Adds 7 days to the current date. |
dateSubtract() |
Subtracts a specified time period from a date. |
dateSubtract(now(), 3, "days") |
Subtracts 3 days from the current date. |
dateBetween() |
Calculates the difference between two dates. |
dateBetween(now(), prop("Due Date"), "days") |
Calculates the number of days between today and the "Due Date" property. |
formatDate() |
Formats a date according to a specified pattern. |
formatDate(now(), "YYYY-MM-DD") |
Formats the current date as "Year-Month-Day". |
timestamp() |
Converts a date into a Unix timestamp. |
timestamp(now()) |
Converts the current date and time into a Unix timestamp. |
fromTimestamp() |
Converts a Unix timestamp into a Notion date. |
fromTimestamp(1609459200) |
Converts the Unix timestamp 1609459200 into a readable Notion date. |
startOfMonth() |
Finds the first day of the month for a given date. |
startOfMonth(now()) |
Returns the first day of the current month. |
endOfMonth() |
Finds the last day of the month for a given date. |
endOfMonth(now()) |
Returns the last day of the current month. |