code for any date greater than last November

  • Thread starter Thread starter JWCrosby
  • Start date Start date
J

JWCrosby

What would the criterion in a query be to select any date later than November
15 of the previous year (the field being a standard date field like
2/3/2009)?
 
If the field actually contains "2/3/2009", a text string, rather than an
actual date/time data type value, you have a different issue.

If the field is a date/time datatype field that just happens to be formatted
to display something that looks like "2/3/2009", then take a look at the
following:

DateSerial(Year(Date())-1,11,15)

will generate November 15th of the year preceding the current year. You can
add your "<" or ">" or ... comparisons to return the records you want.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
That did it! Thanks!

Jeff Boyce said:
If the field actually contains "2/3/2009", a text string, rather than an
actual date/time data type value, you have a different issue.

If the field is a date/time datatype field that just happens to be formatted
to display something that looks like "2/3/2009", then take a look at the
following:

DateSerial(Year(Date())-1,11,15)

will generate November 15th of the year preceding the current year. You can
add your "<" or ">" or ... comparisons to return the records you want.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
Back
Top