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)

Comments

  • dthierjung
    dthierjung Contributor

    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!