Greater than or equal to in query conditions?

Wappler General Need Help
1

I’m currently fetching a date in a query and as I only want to show results that are past a specified date, I want to use >= as a condition in said query, but it seems this is not an option in the dropdown.

I found a post here New Query conditions - lost the ability to use 'Greater than or equal to' which shows you use to be able to select this, but it seems you can’t in Wappler anymore. Is there no way of doing this without recreating my query in a custom query?

2

Can you post a screenshot of what you see? I have it as an option for a date.

Screen Shot 2021-07-07 at 3.56.40 PM
Screen Shot 2021-07-07 at 3.56.40 PM2134×794 180 KB

3

Sure, here’s what I see.

Wappler_Beta_u6WfZyTpT8
Wappler_Beta_u6WfZyTpT8737×322 12.9 KB

4

Be sure that in your database the field type is ‘date’ or ‘datetime’. Looks like you have a ‘varchar’ field you are putting dates into.

5

Yep, that was it, thank you!

Turns out PHPMyAdmin never updated the type to date when I modified the table the first time around due to an error, but after fixing that it updated correctly.

1 Like
6

Glad it is solved. Good luck with your project!

1 Like