[macropod]

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()