Greater than current date

Options
louiswatson
louiswatson Member
in Beast Mode

Hi, I'm working on a beast mode that groups sites into four buckets (Digitisation, Acquisition, Portfolio, Buy Out'. The last 3 are working fine and I just need to setup the formula for 'Digitisation'.

The logic for Digitisation needs to be 'if Contractor completion is greater than or equal to CurrentDate then 'Digitisation'

How would I write this formula?

Tagged:

Best Answer

  • b_rad
    b_rad Contributor
    Answer ✓
    Options

    This is how you do it…

    CASE WHEN (Contractor completion Date >= CURRENT_DATE()) THEN ('Digitisation') END

    Please note that Domo uses the time zone that's setup in your Admin console. I think the default is UTC.

Answers

  • b_rad
    b_rad Contributor
    Answer ✓
    Options

    This is how you do it…

    CASE WHEN (Contractor completion Date >= CURRENT_DATE()) THEN ('Digitisation') END

    Please note that Domo uses the time zone that's setup in your Admin console. I think the default is UTC.

  • louiswatson
    louiswatson Member
    Options

    Thankyou! This worked. I think my formatting was causing the issue previously

Categories