Function to increase Date by 14 days????

  • Thread starter Thread starter James
  • Start date Start date
J

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
 
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.
 
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
Click to expand...


.
Click to expand...
 
Back
Top