Returns the current datetime as YYYY-MM-DDTHH:mm:ss.SSS UTC. The results are of the date-time data type.

This is similar to the JavaScript now.

Expression: Date.now()

Result: 2017-02-21T21:34:22.025 UTC

Parses a string representation of a date, and returns it as YYYY-MM-DDTHH:mm:ss.SSS that matches the server's timezone. The results are of the date-time data type.

This is similar to the JavaScript parse.

This method has the following extensions from the standard:

• parse(millisFromEpoch) - Return a date object that is initialized with the given number of milliseconds from the epoch. If the parameter to parse() is a number, it will be treated as the number of milliseconds from the epoch (Jan 1, 1970) and a new date object will be created and initialized with that value.

• parse(dateString, format) - Parse a date string using a custom format. The second argument is a format string using the same syntax as the Java SimpleDateFormat class.
  
  

• parse(dateNumber, format) - Parse a number as a date using a custom format. The second argument is a format string using the same syntax as the Java SimpleDateFormat class. The number converts to a string and parsed using the given format.

Expression: Date.parse(1445910469510)

Result: 2015-10-27T01:47:49.510 (in the server's timezone)

Expression: Date.parse("2011 10 30", "yyyy MM dd")

Result: 2011-10-30T00:00:00.000 (in the server's timezone)

Expression: Date.parse ($['System Modstamp'],"MM/dd/yyyy'T'HH:mm:ss.SSS'Z'")

Result: 2015-04-15T13:23:10.000 (in the server's timezone)

Expression: Date.parse(20160923, “yyyyMMdd”)

Result: 2016-09-23T00:00:00.000 (in the server's timezone)

Returns the date/time in universal time. The results are of the date-time data type.

This is similar to the JavaScript UTC.

where:

• year is a year after 1900.

• month is an integer between 0 and 11 representing the month.

• day is an optional integer between 1 and 31 representing the day of the month.

• hour is an optional integer between 0 and 23 representing the hours.

• minute is an optional integer between 0 and 59 representing the minutes.

• second is an optional integer between 0 and 59 representing the seconds.

• millisecond is an optional integer between 0 and 999 representing the milliseconds.

Expression: Date.UTC(2015, 7, 20, 13, 23, 12, 34)

Result: 2015-08-20T13:23:12.034 UTC

Returns the date in local time.

Expression: LocalDateTime.parse("2011-10-31")

Result: 2011-10-31T00:00:00.000

Returns the date in local time.

Expression: LocalDate.parse("2011/10/31")

Result: 2011-10-31

Returns the date in local time.

Expression: LocalTime.parse("23:42:00")

Result: 23:42:00.000

Returns the day of the month for the specified date as an integer between 1 and 31.

This is similar to the JavaScript getDate

Expression: Date.parse("2014-09-22").getDate()

Result: 22

Returns the day of the week for the specified date as an integer, where 0 represents Sunday.

This is similar to the JavaScript getDay 

Expression: Date.parse("2014-09-22").getDay() 

Result: 1 (indicating Monday)

This is similar to the JavaScript getFullYear - returns the year of the specified date as an integer.

Expression: Date.now().getFullYear()

Result: 2017

This is similar to the JavaScript getHours - returns the hour for the specified date as an integer between 0 and 23.

Expression: Date.now().getHours()

Result: 21

This is similar to the JavaScript getMilliseconds - returns the milliseconds in the specified date as an integer.

Expression: Date.now().getMilliseconds()

Result: 125

This is similar to the JavaScript getMinutes - returns the minutes in the specified date.

Expression: Date.now().getMinutes()

Result: 34

Returns the month in the specified date as an integer between 1 (January) and 12 (December). This is different from the JavaScript getMonth in that this returns months starting from 1 instead of 0.

Expression: Date.parse("2019-03-04T17:32:53.077 UTC").getMonth()

Result: 3

Returns the month in the specified date as an integer between 0 (January) and 11 (December). Unlike getMonth, this expression is similar to the JavaScript getMonth.

Expression: Date.parse("2019-03-04T17:32:53.077 UTC").getMonthFromZero()

Result: 2

Returns the month according to UTC in the specified date as an integer between 0 (January) and 11 (December). This expression is similar to the JavaScript getUTCMonth.

Expression: Date.parse("2019-03-04T17:32:53.077 UTC").getUTCMonthFromZero()

Result: 11, 0

This is similar to the JavaScript getSeconds - returns the seconds in the specified date as an integer between 0 and 59.

Expression: Date.now().getSeconds()

Result: 22

This is similar to the JavaScript getTime - returns the numeric value corresponding to the time for the specified date according to universal time as the number of milliseconds since 1 January 1970 00:00:00 UTC (epoch time). 

Expression: Date.now().getTime()

Result: 1487712862069

Converts the specified time to its corresponding UTC time. 

Expression: Date.parse("2019-03-04T17:32:53.077").getUTCDate()

Result: 4

Retrieves the year component from the specified date, according to UTC. Values range from 1000 to 9999

Expression: Date.parse("2019-03-04T17:32:53.077").getUTCFullYear()

Result: 2019

Retrieves the month component from the specified time, according to UTC. Values range from 1 (January) to 12 (December).

Expression: Date.parse("2019-03-04T17:32:53.077").getUTCMonth()

Result: 3

Returns the day of the week for the specified date, according to UTC. Values range from 0 (Sunday) to 6 (Saturday).

Expression: Date.parse("2019-03-04T17:32:53.077").getUTCDay()

Result: 1 (Monday)

Returns the hour component from the specified date, according to UTC. Values range from 0 to 23.

Expression: Date.parse("2019-03-04T17:32:53.077").getUTCHours()

Result: 17

Returns the minute component from the specified date, according to UTC. Values range from 0 to 59.

Expression: Date.parse("2019-03-04T17:32:53.077").getUTCMinutes()

Result: 32

Returns the second component from the specified date, according to UTC. Values range from 0 to 59.

Expression: Date.parse("2019-03-04T17:32:53.077").getUTCSeconds()

Result: 53

Returns the millisecond component from the specified date, according to UTC. Values range from 0 to 999.

Expression: Date.parse("2019-03-04T17:32:53.077").getUTCMilliseconds()

Result: 77

Returns the time difference (in minutes) between the specified time and the UTC time.

Expression: Date.parse("2019-03-04T17:32:53.077").getTimezoneOffset()

Result: 0

Returns a string representing the specified Date object.

This is similar to the JavaScript toString.

Expression: Date.parse("2014-09-22").toString()

Result: 2014-09-22T00:00:00.000Z

Returns a string with a language-sensitive representation of the date and time. You can specify the formatting conventions of a given language that should be used and customize the behavior of the function. See Database Date Types for compatible date-related formats when data comes from a database.

The argument to this method is an object containing the following options that control the format of the returned string:

• format: Describes the format of the returned string. See the Joda DateTimeFormat documentation for the full details.

• timeZone: Specifies the target time zone. Use the Canonical ID value from Joda-Time.
  
  

• locale: Specifies the language tag.  

This is similar to the JavaScript toLocaleString.

Expressions: