How can I format a date field to force a specific date format?

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

Guest

The Federal Aviation Administration requires a specific date format on
reports that I use Access to produce. In this format 12/19/04 must be
displayed as DEC 19, 2004. When using mmm dd, yyyy only the first letter of
the month is capitalized. Can I format the field in the table or the report
to force the format?
 
I don't believe it's possible through a field format, but it is using the
Format function (in conjunction with the UCase function).

Assuming you're using a query as the RecordSource for your report, add a
computed field

RptgDate: UCase(Format([MyDateField], "mmm dd, yyyy"))

(replace MyDateField with whatever the field's actually named)
 
The Federal Aviation Administration requires a specific date format on
reports that I use Access to produce. In this format 12/19/04 must be
displayed as DEC 19, 2004. When using mmm dd, yyyy only the first letter of
the month is capitalized. Can I format the field in the table or the report
to force the format?

use Ucase
If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW
 
Yes you can. In the report change on Data tab "Control Source" field to
that: =UCase(Format([DateFieldName], "mmm dd, yyyy")).
DateFieldName is field which contain date. Format will give you your
desired format and UCase will change all to capital letters.
Regards,
Billy
 
The Federal Aviation Administration requires a specific date format on
reports that I use Access to produce. In this format 12/19/04 must be
displayed as DEC 19, 2004. When using mmm dd, yyyy only the first letter of
the month is capitalized. Can I format the field in the table or the report
to force the format?

We just went through this for you on the 9th of December.
You even responded that the reply ... UCase(Format(etc.)) worked.
Why a repeat post on exactly the same question?
 
Back
Top