View Single Post
  #11   Report Post  
Posted to microsoft.public.word.mailmerge.fields
gjupp via OfficeKB.com gjupp via OfficeKB.com is offline
external usenet poster
 
Posts: 10
Default Using dates during mail merge

Yes, this is the comparison that I wish to make, preferably with a space
between month and year. And yes, we wish to make a €˜not equal comparison.

I tried your suggestion, but the merge returned nil results. Word date format
(language €˜English (UK)) was set to €˜dd MMMM yyyy without ordinal. However,
this may have no relevance.

Unless your suggested SKIPIF syntax can be modified, I suppose it will not be
possible to achieve my aim. If so, I shall continue to use SKIPIF with the
comparison date manually inserted at each merge. This will be crude, but the
method will work.

Many thanks indeed for your advice. It is very useful.



Peter Jamieson wrote:
You mean compare with things that are in your data source like

7th February2008
1st March2008

etc?

As long as you can use date and numeric field switches that generate
precisely the date format you need to compare with, you should be able to
use a simlar technique, e.g.

{ SKIPIF "{ MERGEFIELD mydatetext }" "{ DATE \@"D" \*Ordinal }{ DATE \@"
MMMMYYYY" }" }

Haven't tried it myself though, and at best you will only be able to do
exact comparisons (equal or not equal), not determine whether one date is
before the other.

Many thanks indeed. This works fine. However, to go one step further: Is
it

[quoted text clipped - 11 lines]

Many thanks in anticipation.


--
Message posted via http://www.officekb.com