This calendar year minus one

[travismp]

I need to write a query to show me all records that are older than the current year and the last current year that never has to be updated.

I currently have one for month, but need one for year as well.

Year(Date())*12+DatePart("m",Date())-1

Right now I want my query to show anything older than 01/01/2007 because it was not placed this year and anytime last year.

Thank you all.

 

[jdraw]

I need to write a query to show me all records that are older than the current year and the last current year that never has to be updated.

I currently have one for month, but need one for year as well.

Year(Date())*12+DatePart("m",Date())-1

Right now I want my query to show anything older than 01/01/2007 because it was not placed this year and anytime last year.

Thank you all.

I think Year(Date) - 1 will give 2007: that is current year -1

So to use it as you suggest,

Show me things where date-in-record < Year(date) -1

 

[travismp]

OK I will give it a try to see if it gives what I want. Thank you!