Date/Time Filters
Date/Time field filters can be applied to filter your record results in the Builder and Live Apps. To understand how they work with returning records, try out the operators in our app and refer to our operator definitions in the table below.
Filters Available:
| Operators | Sub-Operators | Behavior |
|---|---|---|
| is | N/A | Returns records with the exact date/time entered |
| is not | N/A | Returns all records that do not contain the date/time entered |
| is before | N/A | Returns records that are before the date/time entered |
| is after | N/A | Returns records that are after the date/time entered |
| is before current time | N/A | Returns records before the current date and before the current time (if time values are included) |
| is after current time | N/A | Returns records after the current date and current time (if time values are included) |
| is during the current | week, month, quarter, or year | Returns records that have dates during the current week, month, quarter, or year |
| is during the previous | Number + days, weeks, months, years, rolling weeks, rolling months, or rolling years | Return records that have dates during the previous (number) of days, weeks, months, etc. depending on your sub-operator selection |
| is during the next | Number + days, weeks, months, years, rolling weeks, rolling months, or rolling years | Returns records that are during the next (number) of days, weeks, months, etc. depending on your sub-operator selection |
| is before the previous | Number + days, weeks, months, years, rolling weeks, rolling months, or rolling years | Returns records that are before the previous (number) of days, weeks, months, etc. depending on your sub-operator selection |
| is after the next | Number + days, weeks, months, years, rolling weeks, rolling months, or rolling years | Returns records that are after the next (number) of days, weeks, months, etc. depending on your sub-operator selection |
| is today | N/A | Returns records that have date values of the current day |
| is today or before | N/A | Returns records that have date values of the current day or before |
| is today or after | N/A | Returns records that are during the current day or after |
| is before today | N/A | Returns any records that are before the current day |
| is after today | N/A | Returns any records that are after the current day |
| is blank | N/A | Returns all records that have a blank date/time value |
| is not blank | N/A | Returns all records that have a value included for the date/time field |
Tip: Check out our Date/Time Filters App to learn how the below operators return records with our provided example data tables.
Rolling Dates
Weeks and months in apps are calendar weeks and months.
A calendar week is defined as Sunday through Saturday. A calendar month is defined as the first through the last day of the month.
Rolling weeks, months, and years add more flexible date choices:
Time
An "Any time" checkbox is available in the Builder and in the Live App where you can select "Any time" if you do not need to narrow down your filtered results to a specific time. An "Any date" checkbox is also available:
Note: The "Any time" selection and time input will not be available if you have chosen to ignore time in the Date/Time field's settings.
Additional Notes:
-
When utilizing the "is after the next" filter with the "months" option, the results will encompass dates from the next month, but for example, if the current month has 31 calendar days, the 31st will be part of the returned records.
-
You can apply multiple filters, however, the dropdown selection for and/or will apply to all of the following filters added.
-
We encourage Knack users to experiment with different filter operators to better understand their impact on data retrieval. Check out our date/time filters example app to get an idea of how each operator returns records.
Updated 18 days ago