Current date and before end of the month

louiswatson · November 2022

I'm looking to work out the number of remaining installations left in the current month. I have two columns which have date values (KPI Completed, Completed Awaiting Power).

How would I show data that is greater than or equal to the current date and less than or equal to the end of the current month?

Cheers

MarkSnodgrass · November 2022

You can create a beast mode that looks like this:

CASE when `datefield` >= CURRENT_DATE() AND `datefield` <= LAST_DAY(CURRENT_DATE()) THEN 'Yes'
ELSE 'No'
END

This should work for you.

MarkSnodgrass · November 2022

You can create a beast mode that looks like this:

CASE when `datefield` >= CURRENT_DATE() AND `datefield` <= LAST_DAY(CURRENT_DATE()) THEN 'Yes'
ELSE 'No'
END

This should work for you.

MichelleH · November 2022

@louiswatson Here is the general logic for a beast mode filter you described using one date field:

case 
when year(`Date`) = year(CURRENT_DATE()) and month(`Date`) = month(CURRENT_DATE()) and `Date` >= CURRENT_DATE() then 'Include'
else 'Exclude'
end

We would need to understand the definitions of your two date fields to apply this to your specific use case

Beast Mode

Beast Mode

Current date and before end of the month

Best Answer

Answers

Welcome!

Welcome!

Quick Links

Categories