Embedded SkipIF statement - HELP - CORRECTED

N

Newbie

How can this be changed so that Word Accepts it rign now it does not
allow embeeded skipif statments

{ IF { MERGEFIELD CC_ApptDate } <>"" " {
SKIPIF { = { MERGEFIELD "CC_ApptDate"
\@ "M" }- { MERGEFIELD "CC_DueDate" @
"M" } < 0 }}" "" }


What I am trying to do is included ALL the records where {
MERGEFIELD CC_ApptDate } is BLANK AS WELL AS SOME OF THE RECORDS
where {MERGEFIELD CC_ApptDate } IS NOT BLANK

For the Non blank records I want to eliminate those people whose {
MERGEFIELD "CC_DueDate} is next month and appointment date is this
month {MERGEFIELD CC_ApptDate }

If if I can do this I have not yey figured out how to deal with the
Dec/Jan Math problem

Just so you know I cannnot change the way the data file is genrated
since it is from another program

Just to simplify I want to send cards to those people who do not have
an appointment this month and are due to come in this month and those
who have appointments this month and are due to come in this month. I
do not want to send cards to those people who are due this month but
had there appointments last month (they came in early)

TIA
 
P

Peter Jamieson

I would probably try something like

{ SET M1 12 }{ SET M2 1 }{ SET M3 2
}{ SET M4 3 }{ SET M5 4 }{ SET M6 5
}{ SET M7 6 }{ SET M7 6 }{ SET M8 7
}{ SET M9 8 }{ SET M11 10 }{ SET M12 11
}{ SKIPIF { =or({ COMPARE "{ MERGEFIELD CC_ApptDate }" = "" },
and({ COMPARE { REF "M{ MERGEFIELD CC_DueDate \@M}" } = { DATE \@M },
{ COMPARE { MERGEFIELD CC_ApptDate \@M } = { DATE \@M })) } = 1 }
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top