Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Performing Date calculations in Word
I'm setting up a mail merge document. I need to be able to check if one date
is greater than or equal to 14 days and if so insert a certain piece of text into the document. I've tried to set up a procedure called CheckDate and then use DateDiff to calculate the number of dates but I can't get it to run. Can anyone help? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Performing Date calculations in Word
Is your problem within the procedure, or getting the procedure to run?
It's not easy to run macros within the context of a mailmerge. Another approach is to put the calculation within the MailMerge query itself -- IIF([DateField 1] = [DateField 2] + 14), "Text if yes", "Text if no"), ... "webXpeerience" wrote in message ... I'm setting up a mail merge document. I need to be able to check if one date is greater than or equal to 14 days and if so insert a certain piece of text into the document. I've tried to set up a procedure called CheckDate and then use DateDiff to calculate the number of dates but I can't get it to run. Can anyone help? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Performing Date calculations in Word
The field calculations required to do this in the Word document are
complex - see the linked article at http://www.gmayor.com/insert_a_date_...than_today.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org webXpeerience wrote: I'm setting up a mail merge document. I need to be able to check if one date is greater than or equal to 14 days and if so insert a certain piece of text into the document. I've tried to set up a procedure called CheckDate and then use DateDiff to calculate the number of dates but I can't get it to run. Can anyone help? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reveal codes in a word document | Microsoft Word Help | |||
How do I "reveal codes" in Word the way I could in Word Perfect? | Microsoft Word Help | |||
hard space between words. | Microsoft Word Help | |||
How can Word display full path of a file in the title bar? | Microsoft Word Help | |||
Does Word have a QuickCorrect/Quick Word option like WordPerfect? | New Users |