Parse & Format Date Function Calls

1 Introduction

This document describes functions that are used to parse Date and time values from strings using a specified pattern, or to produce a string from a Date and time value.

For details on all pattern possibilities, see Class SimpleDateFormat.

2 parseDateTime[UTC]

Takes a string and parses it. If it fails and a default value is specified, it returns the default value. Otherwise, an error occurs. The function parseDateTime uses the user’s timezone and parseDateTimeUTC uses the UTC calendar.

2.1 Input Parameters

The input parameters are described in the table below:

2.2 Output

The output is described in the table below:

2.3 Example

The examples below illustrate which value the expression returns:

• If you use the following input:

  parseDateTime('2015-05-21', 'yyyy-MM-dd')
  

  the output is:

  The date May 21st, 2015\. The time will be 12 o'clock at night  because it is not specified.
  

• If you use the following input:

  parseDateTime('noDateTime', 'dd-MM-yyyy', dateTime(2007))
  

  the output is:

  'Mon Jan 01 00:00:00 CET 2007'
  

3 formatDateTime[UTC]

Converts the Date and time value to a string, formatted according to the format parameter. Without the format parameter, a standard format is used. The function formatDateTime uses the users calendar and formatDateTimeUTC uses the UTC calendar.

3.1 Input Parameters

The input parameters are described in the table below:

3.2 Output

The output is described in the table below:

3.4 Example

If you use the following input:

formatDateTime($object/Date1,'EEE, d MMM yyyy HH:mm:ss Z')

the output is:

'Sun, 8 Jun 2008 10:12:01 +0200'

To get ‘1987-12-31T23:59:00’, you need to concatenate two formatDateTime[UTC] functions:

formatDateTime($object/Date1,'yyyy-MM-dd') + 'T' + formatDateTime($object/Date1,'HH:mm:ss')

4 formatTime[UTC]

Converts the time part of Date and time value to a string in a standard format. formatTime uses the users calendar and formatTimeUTC uses the UTC calendar.

4.1 Input Parameters

The input parameters are described in the table below:

4.2 Output

The output is described in the table below:

4.3 Example

If you use the following input:

formatTime(dateTime(1974, 7, 2, 9, 50, 10))

the output is:

'9:50 AM'

5 formatDate[UTC]

Converts the date part of Date and time value to a string in a standard format. formatDate uses the users calendar and formatDateUTC uses the UTC calendar.

5.1 Input Parameters

The input parameters are described in the table below:

5.2 Output

The output is described in the table below:

5.3 Example

If you use the following input:

formatDate(dateTime(1974, 7, 2, 9, 50, 10))

the output is:

'7/2/74'

6 dateTimeToEpoch

Returns the number of milliseconds since January 1, 1970, 00:00:00 GMT to the date.

6.1 Input Parameters

The input parameters are described in the table below:

6.2 Output

The output is described in the table below:

6.3 Example

If you use the following input:

dateTimeToEpoch(dateTime(1974, 7, 2, 9, 50, 10))

The output is:

141990610000

7 epochToDateTime

Creates a Datetime that represents the specified number of milliseconds since January 1, 1970, 00:00:00 GMT.

7.1 Input Parameters

The input parameters are described in the table below:

7.2 Output

The output is described in the table below:

7.3 Example

If you use the following input:

epochToDateTime(141990610000)

The output is:

dateTime(1974, 7, 2, 9, 50, 10)