Links
Comment on page

Date Time

Description

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

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 */

Unknown

An unknown value can be written as UnknownDateTime.

Examples

'2014-08-21' /* Date without time */
'2014-08-21T14:30:00' /* Date with time */

Remarks

The default formatting is determined by the language settings in your Portal Settings.