Time switches/formats

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank - 06 May 2004 11:51 GMT

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

Reply to this Message

Cindy M -WordMVP- - 06 May 2004 15:12 GMT

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 :-)

Reply to this Message

Peter Jamieson - 06 May 2004 15:52 GMT

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.

Signature

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?

Reply to this Message