[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." wrote in message
...
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!

[Igor G.]

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

€žPeter Jamieson€œ wrote:

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." wrote in message
...
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]

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

Peter Jamieson
"Igor G." wrote in message
...
I use Word 2003, and data source accessed with MS Query is 4 Access
queryes.

"Peter Jamieson" wrote:

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." wrote in message
...
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!