How to add time value expression in the db query

Wappler General Need Help
1

Hi,

I would like to add a condition like “events.entrystart >= ( {{NOW}} - 5days)”.
How can I change the 2nd line?

2

Click the dynamic data selector next to NOW, then the magic wand icon to open the formatters, look for the date add formatter and make whatever changes you like.

3

wow!! I could find it!! thank you so much!!