Date & Text Mergefield


Andy Roberts

I have an excel spreadsheet with a column which contains dates. However
some of those dates aren't required sometimes and in these cases the text
string "ASAP" is added instead of a date.

In my word doc I have a merge field which reads...

{MERGEFIELD Date_Required\ @DD/MM/YY}

This returns the dates fine, however where I have ASAP in the spreadsheet
this comes out as the current date (ie Today) instead of ASAP. How can I
get the mergefield to display the date correctly when one has been entered
in the spreadsheet but also display the ASAP text string when this has been
entered instead of a date?

Office 2010
Win XP Pro


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question