Explanation of a query

[BBK]

Can someone be kind enough to explain (in simple terms) what exactly the following is doing.

SELECT Lease.*
FROM Lease
WHERE (((Lease.EndDate) Between Date() And Date()+45));

Sorry for my stupidity

Thank you for taking the time to read this

 

[Brianwarnock]

It is selecting all of the fields in each record in the table lease where the enddate in the record is between todays date and todays date +45 days, dates are inclusive.


Stupidity is not asking when you don't know.

Brian

 

[BBK]

Thank you Brian for the explanation