DateTime Data Types

When configuring filter criteria for dates and times attributes, they must be specified a certain way.

  • Dates can be entered using the date picker, which is the Calendar icon to the right of the date field. Clicking on the Calendar icon displays a calendar from which you can choose the desired date — the selected date is automatically entered in the date field.
  • Times are optional. If entered, they must be entered manually, in the following format:
    hh:mm:ss.nnn where:
    • hh = hour (using the 24-hour clock)
    • mm= minute
    • ss = second

    For example: 15:30:00

    If the time is not specified, Openspace assumes “all times” for the specified date. For example, if you specified “Start Date = 2008-10-04”, with no time, it will return all work items that were started on Oct. 4, 2008, regardless of the time they were started.

    If desired, you can enter just a portion of the time, starting from the left. For instance, you can enter just "10" in the first of the time fields — this means "all times that begin with 10 o’clock".