Ninox Docs
Searchโฆ
Welcome ๐
Tutorial
Introduction
Basics tutorial
Intermediate tutorial
Independent tutorial
Build databases
๐
Enable timezone-independent date
Manage databases
Import and export
Duplicate database
Scripting
๐
Script editor features
Functions overview
Functions categorized
Array
Date and time
Format and convert data
Mathematical
Text
User management
Functions alphabetically
Appendix
Manage account
Create account
Book subscription
Calculate required licenses
Add licenses
Manage licenses
Invite collaborators
Ninox Mac app and iCloud
API
Introduction
HTTP function
Public Cloud APIs
Private Cloud APIs
Private Cloud / On-Premises
Single sign-on (SSO)
Windows Server installation
Docker installation
Sample configuration file
Resources
๐
Release notes
๐ฉ๐ช
Ninox Documentation (German)
๐
Glossary
๐ต
Legacy documentation
โ
Why did we move the old documentation from ninox.com?
Introduction
User interface
Tables
Calculations
Print
Import and export
System requirements
User management, identities and rights
Data synchronization
Data backup
FAQ
Related Links
Ninox website
Community
Webinars
Pricing
Contact us
Imprint
Privacy policy
Powered By
GitBook
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
Previous
Array
Next
Format and convert data
Last modified
9mo ago
Export as PDF
Copy link
Contents
age
appointment
createCalendarEvent
createCalendarReminder
date
datetime
day
days
duration
endof
format
month
monthIndex
monthName
now
quarter
start
time
timeinterval
timestamp
today
week
weekday
weekdayIndex
weekdayName
workdays
year
yearmonth
yearquarter
yearweek