Filter for comparing dates

Daniel Fitzpatrick

Trying to create a filter to only display rows when dates in "Max Obtained Date (LW)" column are greater than dates in "Max License Status Date (NMLS) column. Any ideas?

Paul Newcome

You'll need to insert a helper column that flags rows that meet that criteria. Then you can create the filter based off of this new column.

Paul Newcome

You'll need to insert a helper column that flags rows that meet that criteria. Then you can create the filter based off of this new column.

Matt Small

Create a helper column using an if statement then use that for your filter.

Something like this:
=IF([Max Obtained Date (LW)]@row>[Max License Status Date (NMLS)]@row, 1, 0)

Then the filter is insertNewColumnName = 1.

Do keep in mind you may have to account for null if there is a chance it may be present.

Carson Penticuff

I believe you will need a helper column. (It can be hidden) You can use a checkbox column for the helper and set the formula to:

=IF([Max Obtained Date (LW)]@row > [Max License Status Date (NMLS)]@row, 1, 0)

You can then set your filter to only display rows in which your helper column is checked.

Daniel Fitzpatrick

GOT IT!!! Thanks so much—You're the best😊