How can I use between dateserial to

[zclv05]

How can I use between dateserial to give me the first day of the previous month and last day of previos month.

eg. between #4/1/2003# and #4/30/2003#

The code I used is:
Between DateSerial(Year(Date()),Month(Date()-1),1) And DateSerial(Year(Date()),Month(Date()-1)+1,0)

I am getting back current data from 5/01/2003 - 5/14/2003

Thanks for the help,

 

[MichaelRed]

Error MUST be between the seat and Keyboard (perhaps eyes are involoved in nefarious actions as well)? The statement is in general o.k. for dates where Jan is not a factor. For those, you need to be careful of the year crossover.



MichaelRed
m.red@att.net

Searching for employment in all the wrong places