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

Recommended Answers

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] …
Jump to Post

All 2 Replies

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

Thank you, works a treat!!!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.