Query 7 Days (1 Viewer)

LSTC018 · Jan 17, 2019

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 · Jan 17, 2019

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)

Query 7 Days (1 Viewer)

LSTC018

Registered User.

plog

Banishment Pending

Similar threads

Users who are viewing this thread