Date and datetime fields

Date

This field type stores the date in the following format: YYYY-MM-DD to within 1 day and not specifying the time of the day. The size of the data stored is 4 bytes.

In SimpleOne interface, it is displayed as an input field with a date picker.

A date can be written in three different ways:

YYYY-MM-DD (ISO 8601 format)
DD.MM.YYYY
MM/DD/YYYY

Available symbols in this field:

Numbers
Slash ( / )
Hyphen ( - )
Dot ( . )

Date elements are validated to meet the following criteria:

Element	Range	Comment
Day	[01..31]	The value specified should not exceed this range.
Month	[01..12]	The value specified should not exceed this range.
Year	[0001..9999]	The value specified should not exceed this range.

Date Time

This field type stores the timestamp measured in seconds.

In SimpleOne interface, it is displayed as an input field with a date and time picker.

The datetime can be written in the ISO 8601 format like shown below:

YYYY-MM-DD HH:MM:SS

Datetime elements are validated to meet the following criteria:

Element	Range	Comment
Second	[00..59]	The value specified should not exceed this range.
Minute	[00..59]	The value specified should not exceed this range.
Hour	[00..23]	The value specified should not exceed this range.
Day	[01..31]	The value specified should not exceed this range.
Month	[01..12]	The value specified should not exceed this range.
Year	[1900..2099]	The value specified should not exceed this range.

Date Time Specific