Forum Discussion

spencer_g's avatar
spencer_g
Helper I
9 years ago
Solved

Filter Page to Exclude Current Month

Hi everyone and thanks in advance.    I have 3 years-worth of data that is continually being added to on a daily basis. At the end of each month I generate a report comparing that month and all mon...
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    One way would be to do something like this:

     

    IsCurrentMonth = IF(MONTH([Date]) = MONTH(TODAY()),1,0)

    Then just filter the page with IsCurrentMonth set to equal 0 only.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

One way would be to do something like this:

 

IsCurrentMonth = IF(MONTH([Date]) = MONTH(TODAY()),1,0)

Then just filter the page with IsCurrentMonth set to equal 0 only.

spencer_g's avatar
spencer_g
Helper I
9 years ago

Thanks smoupre!

 

Since I have multiple years worth of data, I had to make one small edition so it ended up looking like:

 

IF(MONTH([Date]) = MONTH(TODAY()) && YEAR([Date]) = YEAR(TODAY()), 1, 0)

 

But otherwise your formula worked like a charm. 

 

Thanks again.