Date fields

[Max]

Hi,
I create a text file in access with the merge fields for a word document.
However I set the output it always includes the time part of the date of
birth as zeros e.g. 12/2/60 00:00:00 which I then have to manually delete
from my word document once the field codes have been unlinked.

I cant seem to control this with format either.

Any suggestions?

Max

 

[Max]

Hi,
Sorry about this.
Just worked it out.
The format identifiers must be upper case for the month other wise it
displays time data.

{ Mergefield DateOfBirth \@ "dd/MM/yyyy"}

Max