Year Criteria

[t0d]

How do I put in a criteria in a query so that it shows all records tha
are dated more than one year from the today's date

 

[fofa]

MyDateColumn < dateadd("y",-1,now()

 

[fofa]

MyDateColumn < dateadd("y",-1,now())

 

[t0d]

That doesn't work. Anyone else have any suggestion

 

[t0d]

That doesn't work. Anyone else have any suggestion?

 

[Douglas J. Steele]

It might help if you showed us what didn't work (as well as telling what was
wrong with it)

 

[John Spencer (MVP)]

Try using "YYYY" instead of "Y". YYYY is the parameter value for Year, Y is the
parameter value for Day of the Year.

 

[John Vinson]

That doesn't work. Anyone else have any suggestion?

What doesn't work?