Hi to all,
just want to insert into my where condition box this statement
{data:keywords2} and {data:keywords3}
I have tried in several ways like this
( `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
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}
This topic is locked and no more replies can be posted.