from =date() show the month in 3 months time in report

[ch4meleon]

I have a report that is a letter and the customer has 3 months to reply to the letter from the date of the letter so i want to have a text boxt on the report that shows the month (only the month not the date) in 3 months time ?
Any help most gratefully received !!

 

[Remou]

Hi
How about:
[tt]DateSerial(Year(Date), Month(Date) + 3, Day(Date))[/tt]

 

[ch4meleon]

Hi Remou
Not sure how you intend me to use this ? (sorry if im being really dense ... blame it on monday morning itis)

 

[ch4meleon]

To clarify i have tried using date part to pull just the month from the date - =DatePart("MM", [text15])this just gives me 27 June 1905 (????)
I have also tried using date add to add 3 months but this still displays a full date and i only want to show the month ???

 

[Remou]

So sorry -
[tt]= Format(DateAdd("m", 3, [Text15]), "mmmm")[/tt]
Where [Text15] is your date field.

 

[ch4meleon]

Remou you're a star thats great and works perfectly !!