Test to see if a specific date falls between two other dates

Airwon48

Hi all,

I am having trouble getting this beast mode to work.

CASE 

WHEN

05-30-2022 >= start_date AND 05-30-2022 <= `end_date`

 THEN 1 ELSE 0

END

or something like this

CASE 

WHEN

 str_to_date('30-MAY-22','%d-%b-%y') >= start_date AND str_to_date('30-MAY-22','%d-%b-%y') <= `end_date`

 THEN 1 ELSE 0

END

Both start_date and end_date are Date data types.

I think I have a data type issue where my statically typed date is not being recognized as a Date data type. Is there a way to turn a typed date (like in my example) into a Date data type?

Thanks,

MarkSnodgrass

your static dates need to have single quotes around them. You could also wrap the static dates and your date field each with a date function so that Domo properly evaluates them.

Airwon48

I feel so stupid!

Thanks for the quick reply, Mark. It works perfectly.