Load a dynamic variable to use in database query condition

Wappler General
21

Try it against your mariaDB and see the output

22

I see that you have made some progress.

The reason why you don’t see less than option is probably because of the data type of the field in DB. Can you please check what it is?

Also, you don’t need set value step. The expression you are creating there can be directly written in query builder - regular or custom.

23

Hi Sid, thnx. Scalaris has put me on the right track.

Yes, I found out about the field data type. Already mentioned it somewhere above.

This morning I succesfully tested my query against a date field (yyyy-mm-dd hh-mm-ss).
Yeah! that works, so I can get it to work this way. Thanks @scalaris !

Still I would like to know if there is a way to turn the “DATE_SUB(NOW(), INTERVAL 7 DAY)” into a timestamp format.

Is there an easy way?

24

Use the .formatDate(…) function with the appropriate datetime mask for your database