Current date and before end of the month

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

Best Answer

  • MarkSnodgrass
    Answer ✓

    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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    Answer ✓

    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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • @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