0

I want to retrieve dates between two dates the user has specified e.g. say the user enters the dates 01/10/2010 amd 05/10/2010 i want to be able to get the dates inbetween the dates entered by the user e.g. 02/10, 03/10....

What possible way is there to do it?

Thanks
tom

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by tomo_uni
0

Create a date data type.
Set it to the initial value.
Use in in while stmt incrementing the date with the DataArr function

NextDay = DateValue(DateStart.Text)
LastDay = DateValue(DateStop.Text)

While NextDay < LastDay
  NextDay = DateAdd("d", 1, nextDay)
        '
        '
        [I]' Your code to process each date[/I]
        '
        '
wend
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.