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

Zofia

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

Zofia

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

david_cunningham

@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

Zofia

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