You can filter date values in various ways using the column filter.
On-Date Search: This option lets you find all data that matches the specified date exactly.
Example: This allows you to determine which service tickets were reported on a specific day: Select the desired day in the "On" filter.
Service-Tickets interface showing ticket list with date filter menu open, displaying November 2019 calendar with date 12 highlighted and "Am" filter option selected.
Before Search: This option allows you to find all data that occurred before the specified date.
Example: Here’s how to view all records with data from previous years: In the “Before” filter, select a date prior to January 1 of the current year.
Service ticket interface showing ticket list from 2019, filter dropdown menu open with date restriction options, and calendar widget displaying January 2020
After Search: Use this option to find all data entries that are on or after the specified date.
Example: If you want to view all service tickets from the current year, select "After December 31 of the previous year" in the "Before" restriction.
Service-Tickets dashboard showing ticket list with dates from 2020, sorting and filtering options menu open, and December 2019 calendar widget displayed
Note: The "Before" and "After" searches can be combined as desired. For example, if you want to view all records for a given year, enter January 1 of the following year as the "Before" date and December 31 of the previous year as the "After" date.
