Date+ 7 days

[Charlie2]

This seemed simple enough to do but upon trying it I cannot get the date to appear in my letter.

I have included the whole text from the letter so you can see where I want the date to be, as you can see the date part is entirely wrong, how can i correct this error.

="If we have not received payment within the next 7 days (Date () + 7)an administration fee of £10.00 will be charged and your account will be passed to our recovery section."

I would like todays date plus 7 to appear in my text, how do i do this?

Charlie

 

[Charlie2]

Its OK

I found a way to achieve this, probably not the correct way but it works for me. Thanks anyways.

Charlie

 

[raskew]

From the debug window:

x = "Pay up by " & format(date()+ 7, "medium date") & " or else."
? x
Pay up by 13-Apr-03 or else.

 

[Charlie2]

LOL

Thats a good one! I just made several more text boxes and cut the text into parts and put the date field in one of its own. It works for me.

Thanks
Charlie