Date stuff

  • Thread starter Thread starter T.
  • Start date Start date
T

T.

Hello everyone,

I need to write a query that looks at the current date's month and pulls all
records where the field PossessionDate is in the next month.

I have been able to pull the value of the months when I pull records from a
date range using DatePart, but have not been able to get it to do what I
need.

Can anyone help me out??

TIA,

T.
 
You might try setting the criteria for your PossessionDate field in query
design view to something like:
=DateSerial(Year(Date()), Month(Date()) + 1, 1) And
Click to expand...
<DateSerial(Year(Date()), Month(Date()) + 2, 1)
 
Thanks much for the suggestion, I just got it going before you posted I
added a calculated field of::

DatePart("m",[PossessionDate]) with criteria = (DatePart("m",Date())+1)

Thanks again!

T.
 
Back
Top