Just wondering if i can format a date within mail merge but, should the field be null then dont display anything for that field. currently i am getting 30/12/1899 00:00:00 for a null date.
To set up the field coding to do this:
1. Make a duplicate of your mailmerge date field, so that you get two fields looking like:
«MergeDate»«MergeDate»
2. Select both of these fields and press Ctrl-F9, to create a set of field braces around the two fields:
{«MergeDate»«MergeDate»}
3. Type inside the nested fields so that they look like:
{IF«MergeDate»= 0 "" «MergeDate»}
4. Press F9 to update
5. Run your mailmerge.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.