For I is startdate to enddate

[MarionD]

Hi there World, I need a bit of help!

Is it possible to use "For I=1 to 10 " using dates? eg. for I=startdate to enddate
where the dates are passed from a form.

Can't seem to get it to work. Not strictly true... it does exactly what I want, but doesn't stop! Starts beautifully on my startdate and then does the loop over over over... not recognising that I is now my enddate! eg. If I have a startdate of 01.01.2017 to 15.02.2017.. it keeps going till I break out... (30.3.2057):banghead:

What am I doing wrong?

 

[Minty]

You'll need to post up the code loop you are using as on Monday's our crystal ball batteries are away being charged up

 

[MarionD]

Sorry folks! Post to hasty!
Problem solved....

Dim I as date of course. Everything works fine now.