How do I create a filter to show Today?

James Sawyer

I would like to create a filter that would only show what I have on the Calendar view for today. I'm sure the same filter would work for a Grid View as well. I have one column that has a start date and one column has an end date.

For Example:

Start Date is 2/10/23 and End date is 2/13/23. If today is 2/11 how do I get it to recognize "today" is in between these two dates?

James Sawyer

Thank you that worked😃

Ipshita

Hi @James Sawyer use a helper column where you enter this formula -

if Start Date is today then 1 and if End Date is today, then 2 (if you want the formula to choose End Date before Start Date then just reverse it)

=IF([Start Date]@row = TODAY(), 1, IF([End Date]@row = TODAY(), 2))

Hope this helps!

Cheers!

Ipshita

James Sawyer

Thank you, this is a good start. However what about the in between dates? In the example below the date is 3/1 and line 15 is blank.

Colleen Patterson

@James Sawyer

In my date helper column I used the following:

=IF(AND(TODAY() >= [Start Date]@row, TODAY() <= [End Date]@row), "true", "false")

This will return true if true, and false if false, and then you would be able to create a filter to show rows where the Date helper column = True

James Sawyer

Thank you that worked😃