Previous Validated Formula now Domo is not accepting

KelNavarro_1206

Please help: I have a beastmode calculation setup before that creates a Date using month number but now Domo is not accepting it.

Here is the formula:

DATE(CASEWHEN LENGTH(`Month Number`)=1 THEN CONCAT(`Year`,'-0',`Month Number`,'-01')ELSE CONCAT(`Year`,'-',`Month Number`,'-01') END)

This is the error message that I am receiving:

ggenovese

It looks like your Month Number is "0" and that's what's causing the issue. Do you see any records in your data that might have a Month Number = 0?

ArborRose

I concur with @ggenovese. Your month number zero is producing invalid values.

DATE(CASE 

    WHEN LENGTH(`Month Number`) = 1 THEN 

        CASE 

            WHEN `Month Number` BETWEEN '1' AND '9' THEN CONCAT(`Year`, '-0', `Month Number`, '-01') 

            ELSE NULL 

        END

    WHEN LENGTH(`Month Number`) = 2 THEN 

        CASE 

            WHEN `Month Number` BETWEEN '10' AND '12' THEN CONCAT(`Year`, '-', `Month Number`, '-01') 

            ELSE NULL 

        END

    ELSE NULL 

END)