Access Query Date Range

[juneau730]

Hi all, I have been racking my head, searching the wonderful world of Google and haven't had any luck finding a solution to my dilemma.

Is there a way to filter a query where a specific date field is >=90 and <365 of today's date? Since my dates in the specific field are "Live" (changing every day).

Thanks in advance for your assistance.

 

[Joe4]

Assuming you are looking for past dates (and note future), but this in the criteria of that field:

Between (Date()-365) And (Date()-90)

If future, try:

Between (Date()+90) And (Date()+365)

 

[juneau730]

Assuming you are looking for past dates (and note future), but this in the criteria of that field:

Between (Date()-365) And (Date()-90)

If future, try:

Between (Date()+90) And (Date()+365)

Correct, I am looking for dates in the past (older than today). Does it matter in which order the -365 and -90 are? Will it work if written as such? (just curious)

Between (Date()-90) And (Date()-365)

 

[juneau730]

For the between 90 and 365 that worked! Thanks so much..

What is the proper string for today >= 90

I have been trying a bunch different ones and some give too much, other give none.

 

[Joe4]

What is the proper string for today >= 90

For more than 90 days in the future, use:

>= (Date()+90)

For more than 90 days in the past, use:

<= (Date()-90)