Date/Time Filters

Learn the behavior of date/time field filters and how they impact record retrieval in this article.

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:

filteringrecords9

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.