Loop through Dates

[Matt]

Is there an easy way to start a loop through days given a beginning and
end date. The first thing that came to mind for me was something like
the following:

***********************************************************************************************************
Dim i as Date

For i = 12/1/2006 To 12/5/2006
Msgbox i
Next i
************************************************************************************************************

This did not work ... when I formatted it it gave me come crazy date
like 1/11/2237. I feel like I have to do something like this, I am
just not sure what.

All Help is Appreciated.
THANKS!

 

[Brian.M.Painter]

Try listing the dates like this
i = #12/1/2006# to #12/5/2006#

 

[Matt]

Try listing the dates like this
i = #12/1/2006# to #12/5/2006#

Brian, you are awesome!

Thanks for the quick response.