Between dates query

D

DaveN

I am trying to display only the events between certain dates. I currently
have the criteria field set up with "Between Dateserial (2005, [Enter start
date (mm)], 1) And Dateserial (2005, [Enter end date (mm)], 31)."

In theory this should work, but if the month only has 30 days and there was
an event on the first day of the following month, I am getting that event on
the list as well. Event though it does not fall within the criteria of the
number of the month requested. (ex: start month 09, end month 09 gives a list
of events from September, but also lists an event on 10/1/2005.

Any Ideas on how to resolve this.

Thanks
Dave
 
F

fredg

I am trying to display only the events between certain dates. I currently
have the criteria field set up with "Between Dateserial (2005, [Enter start
date (mm)], 1) And Dateserial (2005, [Enter end date (mm)], 31)."

In theory this should work, but if the month only has 30 days and there was
an event on the first day of the following month, I am getting that event on
the list as well. Event though it does not fall within the criteria of the
number of the month requested. (ex: start month 09, end month 09 gives a list
of events from September, but also lists an event on 10/1/2005.

Any Ideas on how to resolve this.

Thanks
Dave
Click to expand...

The last day of any month is the 0 day of the following month.

Between DateSerial(..... etc.)
AND Dateserial (2005, [Enter end date (mm)] + 1, 0)."

What do you intend to do with this next month when the year changes?
 
D

DaveN

fredg said:
I am trying to display only the events between certain dates. I currently
have the criteria field set up with "Between Dateserial (2005, [Enter start
date (mm)], 1) And Dateserial (2005, [Enter end date (mm)], 31)."

In theory this should work, but if the month only has 30 days and there was
an event on the first day of the following month, I am getting that event on
the list as well. Event though it does not fall within the criteria of the
number of the month requested. (ex: start month 09, end month 09 gives a list
of events from September, but also lists an event on 10/1/2005.

Any Ideas on how to resolve this.

Thanks
Dave
Click to expand...

The last day of any month is the 0 day of the following month.

Between DateSerial(..... etc.)
AND Dateserial (2005, [Enter end date (mm)] + 1, 0)."

What do you intend to do with this next month when the year changes?
Click to expand...
At this point the databases are seperated by year, and I will just start an
new database. So far the requirement has not been to combine the dates, but
you never know. If you have a different idea for displaying that I would be
interestered. Thanks for your help on this issue, it worked out.

Dave
 
Top