Would DateAdd() help?

DateAdd(mm, 1, myDate)

This would return myDate with 1 month added.

>I need to make the cross-tab from hell ... again.
>
>I get a starting date from a user. That is passed in adn I must Count() patients enrolled in a study on a monthly basis.
>
>Jan Feb March April ...
> 1 1 3 5 the count increments as new pt's are added.
>
>
>I am trying to do the count as a While loop in the fields section of a Select.
>
>In simple terms I am dynamically building the dates from an @i
>
>This test will not increment @i.
>
>While @i <= @NoMonths
>begin
>print @i
>set @i = @1+1
>end
>
>In VFP I'd just gomonth(xxx,1) but I cant seem to figue that one out. So how do I change the value of @i (numeric) in this simple loop?
>
>TIA
>
>__Stephen