DateSerial range prompt 1

[trustsun]

I currently use this date serial paremeter to filter by months. The user will select a month like 1-12. But now I can't see anything if I choose a month. Is it because it's a new year? If so how could I modify this to still see last years data and maybe this years data.

Between DateSerial(Year(Date()),[Select Month (1 - 12)],5) And DateSerial(Year(Date()),[Select Month (1 - 12)]+1,5)

Thanks

 

[r937]

you can't see anything because you're looking for dates between 2005-01-05 and 2005-02-05

what dates did you want to cover?

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[trustsun]

I knew that, but I need to see data up to 2005-01-05 as December when I enter 12 for December 04. Sometimes the data starts on the 31st and ends no later than the 5th the following month.


thanks

 

[Golom]

You need to allow specification of both month and year as in

Between DateSerial([Select Start Year], [Select Month (1 - 12)],5)
    And DateSerial([Select Start Year], [Select Month (1 - 12)]+1,5)

 

[trustsun]

Thanks!