[02bnsv]

I am preparing to send an appeal letter. I have a conditional word merge export setup to conditionally print letters based on appeal package. In one of the package segments, there is a split of people based on current membership expiration date. I need to be able to conditionally change username/password information based on whether or not a member expires on or before a specified date. The problem is that RE exports its word merge date fields as text. Is it possible to use a word formula to convert the text to a number value like the =datevalue(date) formula works in excel? Please advise if you know how to do this. Thanks.

[mwittman]

Quote:

Originally Posted by 02bnsv

I am preparing to send an appeal letter. I have a conditional word merge export setup to conditionally print letters based on appeal package. In one of the package segments, there is a split of people based on current membership expiration date. I need to be able to conditionally change username/password information based on whether or not a member expires on or before a specified date. The problem is that RE exports its word merge date fields as text. Is it possible to use a word formula to convert the text to a number value like the =datevalue(date) formula works in excel? Please advise if you know how to do this. Thanks.

Here's a code snippet I found that may get you going in the right direction:

word mailmerge fields Conditional Formatting?

{IF{MERGEFIELD "CSCS_Test_DateTime" @ YYYYMMDD}> {DATE @ YYYYMMDD} {MERGEFIELD "CSCS_Test_DateTime" @ "d MMM YYYY" *Charformat}
{MERGEFIELD "CSCS_Test_DateTime"  @ "d MMM YYYY" *Charformat}}

Where you format the 'M' in the last two occurrences of 'MERGEFIELD' as you want the output to appear. Change the "d MMM YYYY"
strings to match your preferred date format (eg "dddd, d MMM YYYY", "d/M/YY", etc)