Dateserial Question

  • Thread starter Thread starter Liz Hansen
  • Start date Start date
L

Liz Hansen

Hi,

I need help figuring out the following:

Dateserial that is BETWEEN the first day of the current year AND the
previous month's last date.

So, if I ran the query today it would find data BETWEEN 01/01/04 AND
07/31/04.

Thanks!

Liz
 
Try:
Between DateSerial(Year(Date()), 1,1) And (Date() - Day(Date()))

Might give strange results in January.
 
I'll give it a try.

Thanks!


Allen Browne said:
Try:
Between DateSerial(Year(Date()), 1,1) And (Date() - Day(Date()))

Might give strange results in January.
Click to expand...
 
Alternative method:

Between Between DateSerial(Year(Date()), 1,1) And DateSerial(Year(Date()),Month(Date()),0)
 
Back
Top