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
Functions alphabetically
Appendix
Fields
Ninox languages
Date and time formats
Icons
About "any"
Automatic adjustments
Transactions
Manage account
Create account
Book subscription
Calculate required licenses
Add licenses
Manage licenses
Invite collaborators
Understand usage overview and capacity restrictions
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
π
Create print layouts with Carbone
π
SQL Server connector configuration
Resources
Release notes
π©πͺ
Ninox Docs (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 formats
Token
Description
Example
YY
Year: 2 digits
21
YYYY
Year: 4 digits
2021
M
Month: 1 or 2 digits
1 β¦ 12
Mo
Month: ordinal
1st β¦ 12th
MM
Month: 2 digits
01 β¦ 12
MMM
Month: 3 characters
Feb
MMMM
Month: full name
February
D
Day: 1 or 2 digits
1 β¦ 31
Do
Day: 1 or 2 digits, ordinal
1st β¦ 31st
DD
Day: 2 digits
01 β¦ 31
d
Day: in a week as number (0-6)
0 β¦ 6
do
Day: ordinal in week
0th ... 6th
dd
Weekday: 2 characters
Mo β¦ Su
ddd
Weekday: 3 characters
Mon β¦ Sun
dddd
Weekday: full name
Friday
w or W
Year: calendar week
1 β¦ 53
Q
Year: quarter
1 β¦ 4
l
Lowercase "L" - M/D/YYYY
6/15/2021
L
Uppercase "L" - MM/DD/YYYY
06/15/2021
h
Hour: 1 or 2 digits (12 h)
1 β¦ 12
Previous
Ninox languages
Next
Icons
Last modified
5mo ago
Export as PDF
Copy link