Date and time (Timestamp)

Store a calendar date together with a specific time.

Use a Date and time field when you need to store both a calendar date and a specific time.

For the general settings all data fields have in common, see Shared field settings.

Field-specific settings for Date and Time are:

General

• Default value: fills the field automatically in new records

  • Empty: leaves the field blank
  • Today: uses the current date
  • Edit dynamic value next to the field opens the logic editor where you can add or edit the logic for that setting. After you save the script, Ninox shows the first line of the script instead of the static value field. To switch back to a static value, click Remove dynamic value on the right.

On the form, you can enter the value directly or click the calendar icon on the right side of the field to open the date and time picker. In the picker, you can move between months, select the date, and enter the time.

If the format is set to a 12-hour option, you can switch between AM and PM by typing A or P in the field. You can also press the up and down arrow keys to switch between AM and PM.

Use Date when only the calendar date matters. Use Date and time when the exact time also matters.