T
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
are dated more than one year from the today's date
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
fofa
MyDateColumn < dateadd("y",-1,now()
F
fofa
MyDateColumn < dateadd("y",-1,now())
T
t0d
That doesn't work. Anyone else have any suggestion
T
t0d
That doesn't work. Anyone else have any suggestion?
D
Douglas J. Steele
It might help if you showed us what didn't work (as well as telling what was
wrong with it)
wrong with it)
J
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.
parameter value for Day of the Year.
J
John Vinson
That doesn't work. Anyone else have any suggestion?
What doesn't work?