Memebership Expiry Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want a query that will show memebrship expiry dates within 31 days of a
date I can enter by a box coming up when clicking to run the query.
 
Create a column in your query something like this and put <=31 in the criteria

MyDate: DateDiff("d",[Enter Date],[ExpiryDate])
 
You can also use the dateadd function, to add 31 days to the date entered,
and check id the expiry date smaller then that

Where [ExpiryDate] between [Enter Date:] and DateAdd("d",31,[Enter Date:])
 
Back
Top