0

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)

 

appointment

To convert given time-related values to an appointment

 

createCalendarEvent

To create an event in the Apple Calendar App

 

createCalendarReminder

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

 

monthIndex

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

 

timeinterval

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

 

weekdayIndex

To return a given weekday name as a number

 

weekdayName

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

 

yearquarter

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

Reply

null