date plus a week

[adamj]

i did have some date functions in place in a query in the criteria to show only the records which have the date in the next week....it never particularly worked

im sure theres an easy solution can anyone help?

[wlc04]

If I understand correctly you're wanting data which is in the coming week, right?

You could try something like: between now() and now() + 7

This will always give you anything that falls between today and 7 days from today.

Hope this is what you were looking for. If not, let me know and I'll try to help again.