Query by Date/Time

To search by time such as creation date, completion date or issue date there
are operators that specify the direction of time. The following operators are:

  • between - return information that's amongst two date/time specific values.
  • greater - return data that’s after the specified date/time.
  • less - return information that’s before the specified date/time.

To query a dataset by Date/Time -> Add dataset -> Select a date parameter.

The parameter triggers the operand “between” and two text fields called “ENTER FILTER VALUE” as the default. When placing the mouse pointer into the “ENTER FILTER VALUE” field, the calendar appears with current date and 12:00 AM as the default. The calendar has multiple ways a user can add date/time within the query setup.

Description of the calendar

Element No. Element Description
1. Operators - determines how dates are entered.
2. ENTER FILTER VALUE - where time is entered.
3. Month/Year Identifier - Displays the Month/Year being presented for a search. When calendar is displayed, current month/year appear as default.
4. less than carat - allows user to enter past dates.
5. Greater than carat - allows users to enter current or future dates.
6. weekday - day of the week
7. date of the month - specified day of the month
8. Select Time - switches between the calendar and time panel allowing the user to enter time. Time is displayed as 12 hour.

The calendar has a clock icon that switches to a time panel. In this panel the user select hours and minutes using the increment/decrements button or clicking on pick hour or pick minute. To return back to the calender and select a date click on the calendar icon.

Description of Time


Select Time Description
Select Time: Switches back to the calendar panel
Increment Hour: Increases hour in time
Increment Minute: Increase minutes in time
Pick Hour: Active link it switches to the hour panel where an hour can be choose from numerically (0-12)
Pick Minute: Active link it switches to the minute panel where minutes chosen in increments of 5s (00 thru 55)
Toggle Period: Meridiem Selector
Decrement Hour: Decrease hour in time
Decrement Minute: Decrease minutes in time

Relative time search returns data on the map in relation to the dates specified. It also uses verbiage like:

  • yesterday
  • tomorrow
  • today
  • day (i.e. a day ago, 2 days ago, etc.)
  • week (i.e. a week ago, 2 weeks ago, etc.)
  • month (i.e. a month ago, 2 months ago, etc.)
  • year (i.e. a year ago, 2 years ago, etc.)
  • seconds (i.e. 15 seconds ago, 30 seconds ago, etc.)
  • minutes (i.e. 15 minutes ago, 30 minutes ago, etc.)
  • hours (i.e. 1 hour ago, 2 hours ago, etc.)

Note

If a date/time is not specified during the initial setup; all returned results will display data for the default date/time.

Relative Date/Time

Using days

  • Crimes

    • Incident Date between 9 days ago and 7 days ago (from the current date/time)

  • Crimes

    • Incident Date between 7/22/2016 9:30:00 AM and a week ago

  • Crimes

    • Incident Date between a week ago and today
Using hours
  • Crimes
    • Incident Date between 3 hours ago and 2 hours ago (from the current date/time)
Using greater and less than in relative time

  • Crimes

    • Incident Date greater than 4 days ago

  • Crimes

    • Incident Date greater than a week ago

  • Crimes

    • Incident Date less than 10 hours ago

  • Crimes

    • Incident Date less than 30 minutes ago

  • Crimes

    • Incident Date less than today

Absolute Date/Time

  • Crimes
    • Incident Date between 8/31/2016 9:30:00 AM and 8/31/2016 10:30:00 AM
Using Seconds
  • Crimes
    • Incident Date between 8/31/2016 10:30:00 AM and 8/31/2016 10:30:58 AM
Using greater and less than in absolute time

  • Crimes

    • Incident Date greater than 7/22/2017 11:30:00 PM

  • Crimes

    • Incident Date less than 7/22/2017 11:30:00 PM

Users can apply time series to a search; in return the data will plot on the map based on the defined criteria.

Relative Time Search