How to check date between two Dates?

I want to check Pick up date between two date columns . See below.

I am getting an error Invalid formula

(CASE when
`type`='PICKUP'
AND
`pickup_date` BETWEEN `appt_start_time` and `appt_end_time`
then
1
end)

Find more posts tagged with

I know that Domo should support all MySQL functions, but it looks like it doesn't like the between operator.

You can try using the equivalent statement though:

(CASE when
`type`='PICKUP' AND
`pickup_date` >= `appt_start_time` AND

`pickup_date` <= `appt_end_time`
then 1
END)

Thank you! that worked!