Peter Jamieson wrote:
[cut]
c. (Probably not relevant) By the time the field format switches
operate on the data, all the data is in /text/ format (in other
words, as far as I know, the switches are not working with the
underlying ISO datatime format, they are working with the text string
you see when you just use { MERGEFIELD MYDATE }
[cut]

goal!
i have modified the "select" instruction in msquery
from
select mydate from ...
in
select cast(mydate as char(20)) from ...

and
{ MERGEFIELD MYDATE \@ "dd/MM/yyyy"}
work fine.
tnx.

Bye.

--
Edoardo Benussi -
Microsoft® MVP - Windows Server
http://mvp.support.microsoft.com