PDA

View Full Version : Solved: Merge field Code



Victor
07-31-2011, 05:27 AM
Hi all

I have this field code in a merge letter:


«Fecha_Efectividad_mmddyyyy»

Please see enclosed word 2003 example. 6342

Now I want to get the month part of this table date field code.

Is there a way to do this. Something like:


month(«Fecha_Efectividad_mmddyyyy»)

Or any other suggestion to accomplish this is welcome.

Thanks for the help.

Victor

Victor
08-09-2011, 04:34 PM
After a little research help:

Look here: http://support.microsoft.com/kb/214827/EN-US
and here: http://support.microsoft.com/kb/211363

The final result is:
{IF {MERGEFIELD "Month">}="1" "{IF MERGEFIELD "Month"}<="3" "{IF
{MERGEFIELD "Type"}="1" "$40.00"}" } " "}
The trick for me is to be sure that you enclosed the True and False IF
betwwen " ".
Of course be patient and careful building it.

Thanks

Victor

macropod
08-14-2011, 02:31 AM
Hi Victor,

It seems to me you could do this with:
{={MERGEFIELD Fecha_Efectividad_mmddyyyy \@ "MM"}< 4 \# "'$40.00';;1}