Dates & Timestamps

Dates in the future & past

1
today + 3 weeks | 1 October
2
yesterday - 8 weeks 3 days | 12 July
3
4
3 days from now | 13 September
5
3 days ago | 7 September
6
7
28 days before March 12 | 12 February
8
2 months 3 days after June 5 | 8 August
9
10
days since July 15 | 57 days
11
days till December 25 | 106 days
Copied!

Intervals of time between two dates

1
January 10 - February 5 | 3 weeks 5 days
2
3
3 March to 30 May | 2 months 3 weeks 6 days
4
days between 3 March and 30 May | 88 days
5
6
Monday - Friday | 4 days
Copied!
Intervals of time are calculated from midday on the first date midday to midday on the last date in the interval. Use an inclusive interval function if you want to include both the starting and ending date in the interval (see below)

Inclusive intervals of time between two dates

1
Monday through Friday | 5 days
2
April 1 through April 30 in days | 30 days
Copied!

Time in a month or quarter

1
days in Q3 | 92 days
2
days in February 2020 | 29 days
Copied!

Midpoint between two dates

1
midpoint between March 12 and April 5 | 24 March
2
halfway between today and next Thursday | 13 September
Copied!

Week Numbers (ISO 8601)

1
week of year | 36
2
week number on march 12, 2021 | 10
Copied!

Timestamps

Unix time is a system for describing a moment in time, often used in programming. A timestamp is the number of seconds that have passed since the "reference date" (January 1st, 1970).
1
April 1, 2019 to timestamp | 1554109200
2
1559740303.48 to date | 5 June 2019 at 11:11 pm
Copied!
To get a timestamp for the present moment, use current timestamp
1
current timestamp | 1559740303.48
Copied!

ISO8601 Formatting

ISO8601 is an international standard for formatting dates & times, often used by databases.
1
April 1, 2019 3:30pm as iso8601 | 2019-04-01T15:30:00Z
Copied!
Note: iso8601 formatted dates are not recognised in expressions.
They can be used for formatting answers, or via line references.
Last modified 1mo ago