Prior 18 months - an extra day???? Huh?

[goldfishhh]

Why on earth am I getting an extra day (Dec 31st)?? Too many ")"?

HAVING (((ProdJobABEND.DATE)>DateAdd("m",-18,(Now()-(Day(Now())))) And (ProdJobABEND.DATE)<=Now()-Day(Now())));

 

[PHV]

WHERE ProdJobABEND.DATE Between DateSerial(Year(Now()),Month(Now())-18,01) And (Now()-Day(Now()))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[goldfishhh]

*bangs head against wall*

That did it!