locked
ACCESS 2010 DATE QUERY RRS feed

  • Question

  • Hello,

    I'm a schoolhouse administrator.  I have class iterations of students I need to run a report for when the current date is within 2 months of the graduation date (datGrad) field.  So on 20 April, I would like the query to be populating a 20 June graduating class.

    I know this must be an inanely simply construct, but it has been elusive for quite a while.  Please help!

    Saturday, February 18, 2017 3:12 AM

All replies

  • Hi,

    You could try something like:

    SELECT * FROM TableName WHERE datGrad <= DateAdd("m",2,Date())

    or maybe,

    SELECT * FROM TableName WHERE datGrad Between Date() And DateAdd("m",2,Date())

    Hope it helps...

    Saturday, February 18, 2017 3:44 AM