Time switches/formats

[Frank]

When I try to merge a time field (11am) into word it is diplayed as '1899-12-30 11:00:00' and not '11am' as I would like. I have tried inserting the switch \@ "hh:mm am/pm" into the toggled field code but this make no differance. can anyone explain what is wrong and how to fix this apparent bug

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?RnJhbms=?=,

When I try to merge a time field (11am) into word it is diplayed as '1899-12-30 11:00:00' and not '11am' as I would like. I have tried inserting the switch \@ "hh:mm am/pm" into the toggled field code but this make no differance.

1. which version of Word is this?
2. What's the data source?
3. If you know: what data connection method did you use?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail

 

[Peter Jamieson]

I think the problem here is that Word does not recognise '1899-12-30
11:00:00' as a date because of the year. If it was 1901 or later, your
switch would work correctly.

Your best bet is to fix this in the data source. If you let us know what
that is (and which version of Word), we may be able to help.

--
Peter Jamieson

When I try to merge a time field (11am) into word it is diplayed as

'1899-12-30 11:00:00' and not '11am' as I would like. I have tried inserting
the switch \@ "hh:mm am/pm" into the toggled field code but this make no
differance. can anyone explain what is wrong and how to fix this apparent
bug?