Quote:
Originally Posted by macropod
Hi Aude,
I've tracked down the problem, but I'm not sure what you'll be able to do about it without changing both your existing data and your data input procedures for the future. It's all to do with the default year that your database assumes where there is no date present. Word doesn't handle dates earlier than 1/1/1901, but your data outputs 31/12/1899 (plus the time). As an interim measure, you could:
• do a Directory/Catalogue merge of the data;
• use Find/Replace to change all instances of 31/12/1899 to 1/1/1901;
• then use the merged Directory/Catalogue data as the source for the final mailmerge.
|
Hi,
I have the same problem. I create a access database in access 2010 on windows 8. My date and time field after using (\@ "dd/MM/yyyy" and\@ "HH:mm") displays as i want. The problem starts when i transfer my access file to another PC using XP 32bit and office 2010. When i merge my data the date field is correct but my time fields is like this...31/12/1899 19:00:00. I would like some advise how to correct that, analytical and simple even in pm.
Thanks
Michael