Today is Monday March 3rd. I am using the following Beast Mode (shared previously in the forums) to filter to current month:
Case
WHEN
DAY(CURRENT_DATE()) = 1
AND DATE_FORMAT(`Event Date`,'%m-%Y') = DATE_FORMAT(CURRENT_DATE()-1,'%m-%Y')
THEN '00-Current Month'
WHEN
DAY(CURRENT_DATE()) != 1
AND DATE_FORMAT(`Event Date`,'%m-%Y') = DATE_FORMAT(CURRENT_DATE(),'%m-%Y')
THEN '00-Current Month'
ELSE DATE_FORMAT(`Event Date`,'%m-%Y')
END
I need a beast mode to filter to the month of the last working day (Monday-Friday work week). So for today I would need it to filter the month to February (last working day being Feb 28th) and not March which is what this current beast mode does. If someone has a beast mode they can share that will do this. That would be appreciated.