How do I create a filter to show Today?

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?

Best Answer

Answers

  • Ipshita
    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

    Ipshita Mukherjee

  • James Sawyer
    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
    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


    If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.

  • James Sawyer
    James Sawyer ✭✭
    Answer ✓

    Thank you that worked😃