WHERE syntax in ccv6 for BETWEEN

silvered.dragon 21 Nov, 2019
Hi to all,
just want to insert into my where condition box this statement
WHERE (input_date BETWEEN '2019-01-30' AND '2020-01-30')
the two dates are provided by those two shortcodes
{data:keywords2} and {data:keywords3}
I have tried in several ways like this
model_id.input_date/BETWEEN:{data:keywords2}/AND:{data:keywords3}
but in the log of my mariadb this will result in

( `model_id`.`input_date` BETWEEN '2019-01-30' )

so the second part is always missing.. please give to me a starting point to understand the syntax in the where box.
many thanks
silvered.dragon 22 Nov, 2019
I fixed this using
model_id.input_date/>=:{data:keywords2}
AND
model_id.input_date/<=:{data:keywords3}
This topic is locked and no more replies can be posted.