Query 7 Days

[LSTC018]

Hi,


I am a total beginner looking for a little guidance - I would like a criteria query that will give me records for a total 7 days from a certain date,


Cheers


LSTC

 

[plog]

In the SQL:

WHERE [YourDateField]>Date() AND [YourDateField]<=(Date() + 7)

Or in Query Builder:

Bring down your Datefield, then in its criteria section put:

>Date() AND <=(Date() + 7)