Links

Date and time

An overview of date- and time-related functions

age

To return the number of full years between now and a given date (e.g. a person’s age)
To convert given time-related values to an appointment
To create an event in the Apple Calendar App
To create a reminder in the Apple Calendar App

date

To convert to or return a date value

datetime

To convert to or return a timestamp

day

To return the day of the month from a given date value as a number

days

To return the number of days between 2 dates

duration

To return the duration of an appointment

endof

To return the end of an appointment.

format

To format a given value

month

To return the month from a date value as a number
To return a given month as a number out of a string

monthName

To return the full month name of a given date value

now

To return the current timestamp

quarter

To return the quarter of a given date value as a number

start

To return the start timestamp of an appointment

time

To return the current time
To convert a given time-related value to a time interval, i.e. a duration

timestamp

To convert a given time-related value to a timestamp

today

To return the current date (without time).

week

To return the calendar week of a given date value

weekday

To return the weekday of a given date value as a number
To return a given weekday name as a number
To return the full weekday name of a given date value

workdays

To return the number of working days between 2 given dates

year

To return the year of a given date value.

yearmonth

To return the month and the year of a given date value
To return the quarter and the year of a given date value

yearweek

To return the week and the year of a given date value