Function to increase Date by 14 days????

[James]

I have a word document (invoice) that mail merges in an
Invoice Date.

However I would love to be able to create another field
called PAYMENT DATE. Which would be the Invoice Date + 14
days.

Is there a function I can use to create such a date???

Regards

James Terrington

 

[Jezebel]

You can build it into the SQL query that retrieves the merge data. Insert
([Invoice Date] + 14) as [Payment Date] as one of the query fields.

 

[James]

Must admit that I have no knowledge of Word other than use
of standard functions (need more training I think).

Your response if appreciated though.



James

-----Original Message-----
You can build it into the SQL query that retrieves the merge data. Insert
([Invoice Date] + 14) as [Payment Date] as one of the query fields.

I have a word document (invoice) that mail merges in an
Invoice Date.

However I would love to be able to create another field
called PAYMENT DATE. Which would be the Invoice Date + 14
days.

Is there a function I can use to create such a date???

Regards

James Terrington

.