• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1088
  • Last Modified:

Mail Merge Date Calculation Field

Hi,
I have a mail merge in word.
I want to calculate based on a date field (start_date) for how long  we had doing business with certain client bast on the year. so start_date=  06/05/2001  2007-2001
" We value your loyalty over the past 6 years.
Thanks
Maya
0
mayajhon1
Asked:
mayajhon1
  • 2
2 Solutions
 
GrahamSkanRetiredCommented:
Date arithmetic is very difficult in Word fields. It is much easier to create a separate field in the datasource.
0
 
wittysloganCommented:
0
 
GrahamSkanRetiredCommented:
It's been three months since the question and the first comment, so I guess we can take it that the advice was taken.

wittyslogan,
that link points to a VB(A) method, where date arithmetic is easy. Do you have a way of using it in mail merge?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now