MattioMatt
Registered User.
- Local time
- Today, 14:08
- Joined
- Apr 25, 2017
- Messages
- 99
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:
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?
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:
Code:
<=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?