Compare date in IF statement

Question

I have a Word document that merges with policy data. I need to compare the line of business and the effective date (if greater or equal to January 1, 2012), then insert a Word document. I'm stuck! Thanks for your assistance. PMS

Answer 1

Hi Paula,

Your IF test should look something like:

{IF{MERGEFIELD Line_of_Business_Date @ YYYYMMDD} < {Date @ YYYYMMDD}  "" {INCLUDETEXT "Filepath & name"}}

or:

{IF{MERGEFIELD Line_of_Business_Date @ YYYYMMDD} < 20120101  "" {INCLUDETEXT "Filepath & name"}}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.

Answer 2

Yep, that's what I did. I was looking at it too long! Needed to walk away for a bit. Thanks for the reply.

Answer 3

Should have waited a few hours. I now have it working.