Date/time format

[Paola]

Hi,
I have in the query that supports a report a date/time field, [BirthDate], which is formatted as "14-Mar-03". If I use this field loose when I run the report, it respects the format I chose. When I create the expr: [Nationality]&","&[BirthDate], the report shows it as American, 03/14/2003 .
How can I force my formatting in the report?
Any idea?
Thanks

 

[Douglas J. Steele]

[Nationality] & ", " & Format([BirthDate], "dd-mmm-yy")

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Hi,
I have in the query that supports a report a date/time field, [BirthDate],

which is formatted as "14-Mar-03". If I use this field loose when I run the
report, it respects the format I chose. When I create the expr:
[Nationality]&","&[BirthDate], the report shows it as American, 03/14/2003 .

 

[Paola]

Thanks!!!!!