Time field format

[Igor G.]

I have problem with formatting time fields:

Example:
30.12.1899 7:00:00
....i want to display: 7:00

I try with this code: MERGEFIELD "Time" \@ "HH:mm"
Source is MS Query.
Thanks!

 

[Peter Jamieson]

I think the problem in this case is that Word does not recognise the
incoming value 30.12.1899 7:00:00 as a date/time and does not even try to
apply the format that you specified.

What is the data source that you are accessing via MS Query? Which version
of Word are you using?

Peter Jamieson

 

[Igor G.]

I use Word 2003, and data source accessed with MS Query is 4 Access queryes.

 

[Peter Jamieson]

Is there a reason why you cannot connect directly to the data source (i.e.
without using MS Query?)

Peter Jamieson