[JethroUK©]

Hi

Thanks for that - I tried copy/pasting but i don't think i'm doing right -
it just stays as plain text - it doesn't even have the right-click menu for
fields: Update, Edit Toggle field codes

I've even tried pasting each parameter into the 'IF' wizard seperately


"macropod" wrote in message
...
Hi Jethro,

Try:
{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)

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"JethroUK©" wrote in message
...
I am using excel as a datasource and merging this to create some
appointments for some students

{MERGEFIELD "CSCS_Test_DateTime"}

I need to make the appointments pending very distinct from the history
(in RED maybe?)

Any way i can do this?

{IF {Mergefield "CSCS_Test_DateTime"} Now()