Forums

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

I fixed this using
​

model_id.input_date/>=:{data:keywords2}
AND
model_id.input_date/<=:{data:keywords3}