Valid date formats for the START and END keywords

The valid date formats for the START and END keywords are as follows:

Date format	Description
USA format	You can specify the date in one of the following formats: mm/dd/yyyy mm/dd/yy mm/dd
European format	You can specify the date in one of the following formats: dd/mm/yyyy dd/mm/yy dd/mm
ISO format	You can specify the date in one of the following formats: yyyy/mm/dd yy/mm/dd Warning Important You must specify the year if using the ISO format.

Consider the following points when specifying a date and time:

You can specify the year in a two-digit or four-digit format.
If you specify the year as two digits, Data Collector interprets 00-36 as 2000-2036, and 81-99 as 1981-1999. Values 37-80 are invalid.
If you specify a date without yy or yyyy, the year defaults to the current year (USA and European formats only).
You can specify the date format by preceding the date with one of the following characters:
- U (USA format)
  This is the default format. If you do not precede the date with a character, the interval uses the USA date format.
- E (European format)
- I (ISO format)
You can specify time by using one of the following formats:
- hh:mm:ss (hours, minutes, and seconds)
- hh:mm (hours and minutes)

Example

The following example uses a USA format to request a reporting interval from July 1, 2016 at 10 P.M. to July 31, 2016 at 10 P.M.:

INTERVAL(START(U07/01/16,22:00),END(U07/31/16,22:00)

The following example uses a European format to specify the same interval:

INTERVAL(START(E01/07/16,22:00),END(E31/07/16,22:00)

On this page