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`then1end)
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 1END)
Thank you! that worked!