How to check date between two Dates?

user07441

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)

dthierjung

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)

user07441

Thank you! that worked!