Date Criteria for dates in the future

[MattioMatt]

Hello,

I'm trying to use a query to pull a list of records where the date field ("NextDue") is within the next 90 days from today's date

I've been using this as the criteria in my query:

<=Date()+90

Results (Example):
01/06/2017
18/08/2017

This works but also pulls up dates that are in the past. I'm currently not sure how to get it just so that it works for dates that are not in the past.

I believe I am using the criteria incorrectly as I am asking it for anything less than but I am not sure what else to use to pull the results.

Is it possible?

 

[Minty]

Yes you need to restrict it to both values;

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

 

[MattioMatt]

Minty, as always you are a true star!

Not sure why I did not think of that to start with, thank you so much!!