Ninox Docs
Searchโ€ฆ
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
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