Find records based on a variable date

[Breath of Fresh Air]

I have a simple table with a date field.



I want to be able to extract the records that are newer than a date that I will input.
This date would be different each time but the range would always be the same , eg 6 days

The record set changes so it is not a fixed point in time.

To summarise, need a query that asks for a date to be input, and then returns any records with a date greater than the input date minus 6 days.

Thanks

[orange]

Review the links in the Similar Threads at the bottom of the page. You'll also find some related posts if you search the forum.

[Gicu]

In the criteria row for the date field enter something like this:

>[Enter Date]-6

Cheers,

[CJ_London]

1. extract the records that are newer than a date that I will input.

2. returns any records with a date greater than the input date minus 6 days.

so input date is 10/10/2020 (10th October)

1 requires return of records between 10th and 16th
2 requires return of records between 4th and 10th

which is it? Always better to use example

[Breath of Fresh Air]

yeah I tried that but I get an error message implying the information typed in is not correct. Tried adding # marks for dates inside and outside the brackets

[Breath of Fresh Air]

So input he 16th Oct and it would return everything newer than the 10th

[Gicu]

Please try >CDate([Enter Date])-6.

Cheers,

[CJ_London]

the description of your requirement is still vague

it would return everything newer than the 10th

so you are now saying (if) today is 28th October - you enter 16th October so you want everything from 10th October to 28th October?