Date/time format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
[Nationality] & ", " & Format([BirthDate], "dd-mmm-yy")

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Paola said:
Hi,
I have in the query that supports a report a date/time field, [BirthDate],
Click to expand...
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 .
 
Back
Top