Re: Using dates during mail merge

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.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"gjupp via OfficeKB.com" <u41094@uwe> wrote in message news:7f567b2bcda89@xxxxxx
Many thanks indeed. This works fine. However, to go one step further: Is it
possible to compare the current date with a DateField that is formatted
(typed) dd+ordinals MMMMyyyyy?


Graham Mayor wrote:
You can compare a date in a field with the current date with your skipif
field

{SKIPIF {Mergefield DateField \@ "yyyyMMdd"} <> {Date \@ "yyyyMMdd"}}

Thanks for the reply.

[quoted text clipped - 23 lines]

Many thanks in anticipation.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/word-mailmerge/200802/1


.

Relevant Pages

  • Re: Leading zeroes, text/numbers, import/export
    ... >If I want to do arithmetic, use a numeric format. ... >> We import into Excel and sometimes later export to ... >> can compare them from one list or sheet to another, ... Then, when comparing to other lists or exporting, ...
    (microsoft.public.excel.misc)
  • Re: Help with comparing date stamp in PHP to date AND time stamp coming from MYSQL db!!!!!!
    ... the time limitation to pull the username out of the DB. ... date formats and how to compare them for my little script. ... So when the user logs in again, ... So I can't change the date format ...
    (comp.lang.php)
  • Re: Q: When 0 <> 0 ?
    ... taking the IEEE floating-point format into account, ... I think the answer goes beyond the IEEE FP format to the ... and never compare two FP results ...
    (microsoft.public.excel)
  • Re: Help with comparing date stamp in PHP to date AND time stamp coming from MYSQL db!!!!!!
    ... the time limitation to pull the username out of the DB. ... date formats and how to compare them for my little script. ... So when the user logs in again, ... So I can't change the date format ...
    (comp.lang.php)
  • RE: Date Compare
    ... compare the date/time in the two text fields. ... better means to compare them(the string format), ... There does exists an Date class(javascript class object) which has parse ...
    (microsoft.public.dotnet.framework.aspnet)