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

Airwon48
Airwon48
in Magic ETL

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,

Comments

  • MarkSnodgrass
    MarkSnodgrass Coach

    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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • Airwon48
    Airwon48

    I feel so stupid!

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

Categories