Show current month and next months in a textfield?

[Arjan]

Hi All,

I have a problem with dates..

I have a form with 6 textfields, in every textfield should be the coming 6
months..
So, I have given them the propertie 'mmmm yyyy' so it shows the month and
year.
The standardvalue (for the first) is '=Date()'so it shows the current month
and year..

Now it comes, the next textfields has to show 'current month + 1 month',
'current month + 2 months', ..., 'current month + 5 months'.
I think it should be something like '=Date()+1' , '=Date()+2', ...,
'=Date()+5'.
However, as you can guess that doesn't work..

Does anybody know how I can do it?

thamks for your help!!

Arjan
the Netherlands

 

[Douglas J Steele]

=DateAdd("m", 1, Date()), =DateAdd("m", 2, Date()), etc.

 

[Arjan]

Douglas,

Thanks for you reply.
When i put the code '=DateAdd([m];1;Date())' in my textfield the result is
#name?

do yo have any idea?

thanks again..

Arjan




thnxs for your reply, However, when I use this code

 

[Arjan]

Douglas,

I figured it out..
It is: =DateAdd("m";1;[Date])

Thanks for you help!!!