Beast Mode Calculation

Options

Hello - I'm trying to calculate a Beast Mode so that it only shows the stats for completions if the date is not greater than today. After checking out some questions and responses in the community I tried the below, but it doesn't work πŸ˜• Clearly I'm doing something wrong and would appreciate some guidance.

CASE WHEN `Completion Date`>= CURRENTDATE() AND MONTH`Completion Date` = MONTH(CURRENTDATE()) THEN 'Include' ELSE 'Exclude' END

Best Answers

Answers

  • MichelleH
    Options

    @Marcy It looks like you were using a greater than operator instead of less than. In that case you wouldn't need the month condition. Here is what it would look like:

    case when `Completetion Date` <= CURRENTDATE() then 'Include' else 'Exclude' end
    
  • Marcy
    Options

    @MichelleH - Thank you for the quick response. When I click to validate the translation it throws up a calculation error, This calculation is using a nonexistent function.

  • MichelleH
    MichelleH Coach
    Answer βœ“
    Options

    @Marcy Try using CUR_DATE() instead of CURRENTDATE()

  • Marcy
    Marcy Member
    Answer βœ“
    Options

    @MichelleH - it worked a treat, many thanks.