Comment on page
Date Time
This is the datatype that stores date and time information. The contents of a date consist of several parts in the following units.
- Year
- Month
- Week
- Day
- Hour
- Minute
- Second
- Millisecond
These units can be used in date-time functions in the expression editor.
Formatting of date time values can also be controlled using format strings. Some examples for formatting
'2014-08-21 14:30'
are shown below. (empty) /* 21-8-2014 14:30:00 */
MM-dd-yy /* 08-21-14 */
MMMM d yyyy /* August 21 2014 */
dddd MMM d /* Thursday Aug 21 */
d/M/yy HH:mm /* 21/8/14 14:30 */
hh:mm:ss /* 02:30:00 */
h:mm tt /* 2:30 PM */
An unknown value can be written as
UnknownDateTime
.'2014-08-21' /* Date without time */
'2014-08-21T14:30:00' /* Date with time */
Last modified 1yr ago