Thank you in advance. I'm trying to pull all inventory items from December
of the previous year back to 4 years for my accountant. I know this can be
done, but I'm drawing a blank. I've tried;
DateDiff("y",-4,DateIn) and get errors
Please any assistance would be greatly appreciated.
Michael
This was my original post. I'm sorry, I meant to ask, how can pull records
from December of last year, programmatically changing each December to the
previous 4 years, to allow them to be dropped from inventory for taxes?
Cooking the books eh? <g>
DateDiff("yyyy",-4,DateIn)
--
A)bort, R)etry, I)nfluence with large hammer.
This gives me NO records and I know there are records older than 4 years.
I've tried:
DateDiff("yyyy",-4, [DateIn]) and get NO records. This should be records
older than 4 years, should it not? Then I tried:
DateDiff("yyyy",-1,[DateIn]) still NO records. Then I tried;
DateDiff("yyyy",0,[DateIn]) Still NO records in my query.
PLEASE help me. I'm trying to take all inventory from December back four
years out for tax purposes. I would like the query to do it programmatically
each December for the previous four year ago inventory!
So 2004, 4 years back would mean all my 1998 inventory would not show on
this Query. In 2005, I would like all my 1999 inventory to do the same
thing. And so on and so on!
DateIn is the field that shows when the inventory was added, using a short
date mm/dd/yyyy!
Thank you again for all your help.
Michael