What's the beast mode to show only the current month and next month?

Options
Zofia
Zofia Member

Hi, need help to show only the current month and next month from my schedule data, but the current month should starts with the 1st day of the month. For example, my pivot table should show only May and June. I have the below beast mode that I put in filter and filter by 'SHOW' to get only May and June but the problem is the data starts from May 15 since I'm using Curdate formula, I can't find any formula that will result to show only data from May 1 to June 30

CASE WHEN Date <= DATE_ADD(CURDATE(), INTERVAL 2 MONTH) and Date > DATE_SUB(CURDATE(), INTERVAL 0 MONTH)
THEN 'SHOW'
ELSE 'HIDE'
END

Best Answer

Answers

  • david_cunningham
    Options

    @Zofia here you go!
    
     The way this works is that we compare the month and year of the date to the month/year of the current date.  We use date_add to add a month.  This should work across year changes as well.
    
      
    
    CASE
    WHEN MONTH(CURRENT_DATE()) = MONTH(date) and YEAR(CURRENT_DATE()) = YEAR(date) then 'Show'
    WHEN MONTH(DATE_ADD(CURRENT_DATE(),INTERVAL 1 MONTH)) = MONTH(date) and YEAR(DATE_ADD(CURRENT_DATE(),INTERVAL 1 MONTH)) = YEAR(date) then 'Show'
    ELSE 'Do Not Show'
    END

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

  • Zofia
    Zofia Member
    Answer ✓
    Options

    @david_cunningham This is exactly what I need. Thank you so much, appreciate your help.