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
Monday through Friday | 5 days
April 1 through April 30 in days | 30 days
Time in a month or quarter
days in Q3 | 92 days
days in February 2020 | 29 days
Midpoint between two dates
midpoint between March 12 and April 5 | 24 March
halfway between today and next Thursday | 13 September
Week numbers (ISO 8601)
week of year | 36
week number on march 12, 2021 | 10
Day of the week on a particular date
day of the week on January 24, 1984 | Tuesday
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).
April 1, 2019 to timestamp | 1554109200
1559740303.48 to date | 5 June 2019 at 11:11 pm
To get a timestamp for the present moment, use current timestamp
current timestamp | 1559740303.48
ISO8601 is an international standard for formatting dates & times, often used by databases.
April 1, 2019 3:30pm as iso8601 | 2019-04-01T15:30:00Z
Note: iso8601 formatted dates are not recognised in expressions.
They can be used for formatting answers, or via line references.