Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
IPandA IPandA is offline
external usenet poster
 
Posts: 1
Default Field calculation error using calculated dates


I am using Word 2003. The document includes mail merge fields for several
dates and derives additional dates based on one of the mail merge fields.
Based on comparisons between sets of dates, I generate conditional text.

The section below is typical of what I want to accomplish:
Given mail merge fields for a reference date and a next payment date, I want
to compare the next payment date to the reference date, and if the next
payment date occurs after the reference date, calculate a date 1 day prior to
the next payment date, and generate the appropriate conditional text.

Between {DATE \@ "MM/dd/yy"} and {IF {MERGEFIELD PaymentDueDate \@
"mmdyyyy"} = {MERGEFIELD Extended_EFS_DATE \@ "mmdyyyy"}
"{MERGEFIELD Extended_EFS_DATE \@ "mmdyyyy"}"
"{QUOTE
{SET Delay -1}
....
"{mm}-{dd}-{yy}" \@ "MM/dd/yy}"}, you must pay ${ REF AmtDue}.

I am experiencing problems very similar to those reported by Lani in a post
dated 2/3/2006. I get a Field Calculation Error message for each record in
the data source (although the calculated results generally appear to be
correct) and I am getting a -2 days delay whenever I use a February
NextPaymentDate. I am using macropod's n days delay as a starting point.

Would apprectiate any help.
--
IP&A
Reply
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
field calculation error message Eloy Mailmerge 6 September 27th 06 05:27 PM
Field Calculation Error Frank Mailmerge 1 July 18th 06 04:40 AM
Why do I get Field Calculation Error when I Mail Merge? cagearoo Mailmerge 2 March 16th 06 07:49 PM
Calculation field error moombi Tables 0 June 9th 05 01:40 PM
field calculation error, mailmerge, Cindy M -WordMVP- Mailmerge 0 November 30th 04 05:25 PM


All times are GMT +1. The time now is 06:26 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"