Posted by Notgiven on 01/23/06 14:34

"Notgiven" <notreallyme@invalid.invalid> wrote in message
news:wacAf.425$f57.407@bignews7.bellsouth.net...
> Say you have two dates, 2005-01-01 and 2005-01-24. I want to get a list or
> array or all the date between and including those two dates.
>
> I want to include this list in a query so I need it in a format like:
> '2005-01-01', '2005-01-02',...
>
> Any ideas? thanks

Wow - thanks so much to everyone who posted their ideas and functions!

Regarding the use of BETWEEN in sql code, I needed this function in case I
can't figure out a way to check for overlapping TIME and DATE interval in
the sql code. If I can't, I would simply add records for every day of an
event instead of a start and end date. That way, I would only check for
overlapping time within each day in the records.

Thanks again!

[Back to original message]