Syntax
DATE(date, format, timezone)
Usage examples
Example 1
Formula | DATE("2022-07-17", "%a, %b %d, %y") |
Output | "Fri, Jul 17, 21" |
Example 2
Formula | DATE("2021-07-17", "%Y") |
Output | "2021" |
Example 3
Takes DATE_PARSE objects
Formula | DATE(DATE_PARSE("05/04/1994", "%d/%m/%Y"), "%B %e, %Y") |
Output | "April 5, 1994" |
Example 4
Many different representations of dates are supported
Formula | DATE("March 17, 2021", "%b %d, %y") |
Output | "Mar 17, 21" |
Example 5
Natural language dates are supported. See chronic for more examples.
Formula | DATE("fourteenth of May 2024", "%Y-%m-%d") |
Output | "2024-05-14" |
Example 6
Relative times are supported. See chronic for more examples.
Formula | DATE("tomorrow at 10am", "%Y-%m-%d %H:%M:%S") |
Output | "2023-05-22 10:00:00" |
Example 7
Unix timestamps are supported
Formula | DATE(1647712411, "%Y-%m-%dT%H:%M:%S") |
Output | "2022-03-19T17:53:31" |
Example 8
Unix timestamps with 13+ digits are treated as milliseconds
Formula | DATE(1687450077063, "%Y-%m-%dT%H:%M:%S.%L") |
Output | "2023-06-22T16:07:57.063" |
Example 9
To get the current time, pass the keyword "now"
(or "today"
)
Formula | DATE("now", "%Y-%m-%d %H:%M") |
Output | "2022-03-11 16:24" |
Example 10
Defaults to iso8601 format with three decimal places if no format is provided
Formula | DATE("now") |
Output | "2022-03-11T16:24:01.123Z" |
Example 11
Takes optional timezone argument
Formula | DATE("2023-05-19 12pm", "%Y-%m-%d %H:%M:%S %Z", "Asia/Tokyo") |
Output | "2023-05-19 21:00:00 JST" |