Dates in For Loop in vb.net

Question

Hello,

In vb.net I have two data values as shown below:

Dim startp as datetime
Dim endp as datetime

I have a function called ProcessData(soemdate) which processes dataporting.

In VB.net is there a way I can do something like

For each day between startp and endp
 ProcessData(soemdate)
Next

Thanks

Answer 1

For Each Day As DateTime in Enumerable.Range(0, (endp - startp).Days) _
                            .Select(Function(i) startp.AddDays(i)) 
    ProcessData(Day)
Next Day

Answer 2

Yes, you can use an accumulator date:

Dim Accumulator as DateTime
Accumulator = startp

While (Accumulator <= endp)


    Accumulator = Accumulator.AddDays(1)
End While

Not tested, and I'm a C# programmer, so be easy if my syntax is wrong.

Answer 3

Here is another way to do this.

Dim startp As DateTime = New DateTime(2009, 1, 1)
Dim endp As DateTime = New DateTime(2009, 2, 1)
Dim CurrD As DateTime = startp

While (CurrD <= endp)        
    ProcessData(CurrD)
    Console.WriteLine(CurrD.ToShortDateString)
    CurrD = CurrD.AddDays(1)

End While