Dreaded DateAdd ?

[WineSnob]

I am filling a table with calculated data. There is a StartDate field (supplied as a variable) I need to fill the table with the next month first day. It is a payment due schedule.
I will supply 1/1/2013 then I need to fill the table with
2/1/2013
3/1/2013
4/1/2013 ....etc until end of loop.
I have tried
ScheduledPaydate= StartDate.Addmonths(1)
I tried
ScheduledPaydate = DateAdd("m", 1, startdate)

Any ideas?
Thanks

 

[jdraw]

What is the issue/error?
See http://www.access-programmers.co.uk/forums/showthread.php?t=238821
for database of several Date-related functions by Pat Hartman.

 

[Brianwarnock]

You are not increasing the month as you loop
Don't know if you can DateAdd("m",n,startdate) where you increase n by 1 each time round the loop, but you can with Dateserial.

Dim M as Long

For M =1 to 11
DateSerial(Year(startdate),Month(startdate) + M,1)

next M

Brian

 

[WineSnob]

Thanks Brian - That did it.

 

[Brianwarnock]

HTH, raise a glass to learning and AWF

Brian