Re: 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

.

Relevant Pages

  • Re: Using dates during mail merge
    ... Word MVP web site http://word.mvps.org ... Peter Jamieson wrote: ... Unless your suggested SKIPIF syntax can be modified, ... precisely the date format you need to compare with, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Using dates during mail merge
    ... OK, it certainly works here, i.e. in principle, so maybe the detail needs checking: ... Unless your suggested SKIPIF syntax can be modified, I suppose it will not be ... Peter Jamieson wrote: ... precisely the date format you need to compare with, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Using dates during mail merge
    ... "Graham Mayor" wrote in message ... Peter Jamieson wrote: ... Unless your suggested SKIPIF syntax can be modified, ... precisely the date format you need to compare with, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Can I AutoSize (or Fit) merged, variable data within a text bo
    ... i have had to manually format my pages as they ... "Peter Jamieson" wrote: ... The problem became a problem when my client decided that they no ... PrintShop Mail is made for this kind of gig ...
    (microsoft.public.word.mailmerge.fields)
  • Re: DataGridView, Formatting a Numeric Column
    ... setting the Format after setting the Alignment. ... I'll be doing some more trashing about in the documentation and the ... further advice I'd be most grateful. ... (Not that the doc said "n" would provide right justification, ...
    (microsoft.public.dotnet.languages.vb.controls)