Word merge date between two dates 1

[cjashwell]

Hi there. Does anyone know how to use Word fields to evaluate a date passed from a mailmerge field to see if it falls between two dates?

For example, if I want to know whether 10th September 2007 is between 1st September 2007 and 15th September 2007, how do I do this?

Assuming the Date merge field contains the 10th September 2007 (in some format), I would have thought that this would work:

{IF {=AND({MERGEFIELD Date}> 01092007, {MERGEFIELD Date}<15092007)}=1, "Between" "Not Between"}

But it doesn't. I'm using Word 2002. Does anyone have any suggestions? Thanks in advance.

 

[macropod]

Hi cjashwell ,

Try:

{IF{=({MERGEFIELD Date\@ YYYYMMDD} > 20070901)*({MERGEFIELD Date\@ YYYYMMDD} < 20070915)}= 1 True False}

Cheers

[MS MVP - Word]

 

[cjashwell]

Great - that does seem to work. Thank you very much indeed.

Can you tell me where this is documented, as I searched offline and online Help quite extensively but didn't find any references to this technique?

 

[macropod]

Hi cjashwell,

I'm not aware of any MS doco going into this sort of detail.

Howevre, I've written a couple of 'tutorials' on date calutions and field maths generally, both of which you can download from:

http://www.gmayor.com/downloads.htm#Third_party

Cheers

[MS MVP - Word]

 

[cjashwell]

Thanks for your help macropod, and for linking to that very valuable resource. Best wishes.