Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
walkerh walkerh is offline
external usenet poster
 
Posts: 2
Default if statements with dates in mailmerge

This has me puzzled. We have a mailmerge document populated from an external database via a header and text file. In the letter we compare a Start Date with an End Date. If they are the same the letter only prints the Start Date m/d/y. If the End Date is greater than the Start Date, we format the Start Date for month/day add a dash and format the End Date month/day/year. We just ran into a case where if the month and day are the same in the Start Date and the same in the End Date the test fails and only the Start Date is printed. An example would be SD = 04/04/2007 and ED = 06/06/2007. changing the SD to 03/03/2007 or 05/05/2007 or the ED in similiar fashion yields the same failure. A difference in the year results in the desired behavior. Any thoughts?

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
assistnace with mailmerge dates from excel Woods Mailmerge 2 May 26th 05 06:29 AM
Mailmerge calculated dates from Excel MervynW1954 Mailmerge 3 April 22nd 05 10:58 AM
Word Mailmerge reading UK dates in Access as US dates Curious of Barnet Mailmerge 4 April 18th 05 12:36 AM
Mailmerge Dates Greg Smart Mailmerge 2 March 18th 05 07:27 PM
Mailmerge Dates [email protected] Mailmerge 0 March 18th 05 02:47 PM


All times are GMT +1. The time now is 03:32 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"