Hi,
in addition to use the query within " ... " rather than { ... } and using the right iso format for $days,
e.g. what comes back from "select now();":
2001-12-20 10:36:53+01
I think you have to write '$date'.
And you don't have to use ::interval, simply add the number
of days, e.g. "now() + 7".
Peter.
