Dateserial Question

[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

 

[Allen Browne]

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

Might give strange results in January.

 

[Liz Hansen]

I'll give it a try.

Thanks!

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

Might give strange results in January.

 

[John Spencer (MVP)]

Alternative method:

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