Date Beast mode

NFerna
NFerna Member
in Beast Mode

Hi everyone,

I have a pivot table which contains plan data. The key point is we need to allow one month post plan completion to allow for data collection and input.

Country

Plan Name

Start Date

End Date

Status

Delivered data available

Austria

Plan 1

1st Jan 2024

1st March 2024

COMPLETED

YES

Malta

Plan 2

1st Jan 2024

1st June 2024

LIVE

NO

In this example, i have used a beast mode to populate status if end date is before current date then completed, else live. I am having issues creating the beast mode for the "delivered data available" column. The logic is:

If campaign end date +1 month, is before current date, then YES, else NO (e.g. if plan end date is 1st March, data is available from 1st April). is this possible as a beast mode and how would I go about formulating this?

Thanks!

Tagged:

Best Answer

  • twaldron
    twaldron Member
    Answer ✓

    You should be able to use a beast mode like this:

    CASE
    WHEN ADDDATE(`End Date`, INTERVAL 1 month) <= CURDATE() THEN 'Completed'
    ELSE 'LIVE'
    END

Answers

  • twaldron
    twaldron Member
    Answer ✓

    You should be able to use a beast mode like this:

    CASE
    WHEN ADDDATE(`End Date`, INTERVAL 1 month) <= CURDATE() THEN 'Completed'
    ELSE 'LIVE'
    END

Categories