This documentation supports the 19.08 version of Remedy Action Request System.

To view an earlier version, select the version from the Product version menu.

Date and time fields

There are three types of date and time fields:

  • Date/Time — Stores calendar dates and time together. You can set the Display Type property to Just Date or Just Time so that users see only the date or time.
    BMC Remedy AR System stores date/time values as the integer number of seconds since 00:00:00 GMT, January 1, 1970. Dates from January 1, 1970, through January 18, 2038, GMT are valid in date/time fields.
    If users enter only a time, the current date is assumed. If users enter only a date, the time defaults to 12:00:00 A.M.
  • Date — Stores date information only as the number of days from the beginning of its range. Use a Date field to compare two dates or to perform calculations based on the date, such as calculating the number of days between two dates. Users can enter dates from January 1, 4713 B.C.E., to January 1, 9999 C.E.

  • Time — Stores time information only as the number of seconds from 12:00:00 A.M. Use a time field to compare two times or to perform calculations based on time, such as the number of elapsed seconds.
    The value in a time field is independent of the time zone. While a date/time field adjusts the displayed value to reflect the user's time zone, the time value in a time field remains unchanged when displayed on the client.

    Warning

    Because values stored in date/time, date, and time fields are not equivalent, setting, pushing, or merging values among these fields might produce unexpected results.


    The format for these fields matches the locale specified in the user preferences. If no user preference for locale exists, user environment settings are used (for example, Regional Settings Properties in the Windows Control Panel).

Supported formats for date and time field

  • yyyy-MM-ddTHH:mm:ss.SSSZ
    For example, 2019-02-20T15:00:00.000Z
  • yyyy-MM-dd'T'HH:mm:ss.SSSSSSSSSZ
    For example, 2019-01-19T09:55:50.111111000-0800
  • yyyy-MM-dd'T'HH:mm:ssZ
    For example, 2019-01-13T15:33:00-0800
  • yyyy-MM-dd'T'HH:mm:ss
    For example, 2019-05-11T22:33:44

For more information, see Date and time formats supported by web service.

For information about workflow considerations for date/time, date, and time fields, see information about keywords and assigning values using function results in Defining workflow to automate processes.

Was this page helpful? Yes No Submitting... Thank you

Comments