How to add <= and >= to, conditions to paged queries

[JBM]

Here is a screen shot of the conditions tab for a paged query. The ui does not provide the option for a conditional condition, say: date_created >= $_GET.start_date && date_created <= $_GET.end_date

[Teodor]

Simply use the group icon, to create a group with multiple conditions inside, where you can set the relations between them to AND or OR

[JBM]

Hi Teodor these are the options I have, Im guessing because the data in the table for date_created is a varchar and not a date it gives me these options:

[Teodor]

Yes, that is the issue. The data picker does not know that you're storing dates there. You need to use date/datetime fields for storing dates.

[JBM]

Thanks Teodor