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.

Guido_Beulen's avatar
Guido_Beulen
Helper I
3 years ago

You can filter on calendermonth using relative date: this excludes the current month from the data shown: 

The same is possible for years and weeks!