Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hi Chris,
To compare two dates you need to express them in ISO format (i.e. YYYYMMdd). For example: {IF{MERGEFILED Date1 \@ yyyyMMdd}{CalculatedDate \@ yyyyMMdd} "True Result" "False Result"} To do math with dates in Word, you can't simply subtract a number from a date in a mailmerge. To see how you can go about this, or do date comparisons and much more with dates, download the Word document at: http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 (url all one line) Cheers "Chris ferb" Chris wrote in message ... I have set up a mail merge with an access database. The merge works fine, but I am trying to display different messages if a date is from 90 days previous. I have been using the following logic from my date field in the "If then else" option: [date] (date-90) I have data in the date field that should make the code trigger the the else but it does not. Thanks for your help. |
#2
|
|||
|
|||
Using If Then and Else with dates in a mail merge
I have set up a mail merge with an access database. The merge works fine, but
I am trying to display different messages if a date is from 90 days previous. I have been using the following logic from my date field in the "If then else" option: [date] (date-90) I have data in the date field that should make the code trigger the the else but it does not. Thanks for your help. |