1. Using Core Application
  2. Date and Time Editors in Search Filters

Date and Time Editors in Search Filters

You can see date and time editors on predefined date and time properties in the search filter on the Dispatch Console pages and the Nearby Activities page. When the administrator adds a ‘date and time’ or ‘time’ field to a search filter, you can see a date and time editor. Apart from this, you can also see a placeholder with the format in which you must enter the value.

The date and time or time editor is shown for these predefined properties:
  • ETA (label: ETA)
  • Service Window Start (label: service_window_start)
  • Service Window End (label: service_window_end)
  • Delivery Window Start (label: delivery_window_start)
  • Delivery Window Start (label: delivery_window_end)
  • Communicated Window Start (label: ctime_delivered_start)
  • Communicated Window End (label: ctime_delivered_end)
  • SLA Window Start (label: sla_window_start)
  • SLA Window End (label: sla_window_end)
  • Time of Booking (label: atime_of_booking)
  • Time of Assignment (label: atime_of_assignment)
  • Route Activated (label: activated)
  • Route Deactivated (label: deactivated)
  • Route Reactivated (label: reactivated)

The "date time" or "time" editor is displayed only when one of these four conditions is selected for the filter condition: <, >, <=, >= (less than, greater than, less than or equal to, greater than or equal to). All other conditions accept either several values or a part of the string representing the date or time. That's why those conditions have no date or time editor.

The format used with the date or time property within a filter is specified on the individual user's Preferences page (accessed by clicking their avatar and selecting Preferences). If the editor isn't available because the condition being used isn't one of the supported ones, use the ISO format:

  • Date: yyyy-mm-dd
  • Time (in 24-hour format): hh:mm

Remember that the format for date and time properties that you choose on your individual Preferences page apply to the search filters as well.

The "date time" or "time" editor isn't displayed in these conditions:

  • Contains / Does not contain: With these conditions, users can enter part of the date or time, which can't be interpreted by the "date time" or "time" editor.
  • Starts with / Does not start with: With these conditions, users can enter part of the date or time, which can't be interpreted by the "date time" or "time" editor
  • In / Not in: Several values can be entered with these conditions, so they aren't supported by the editor.