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

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?
 
D

Douglas J. Steele

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)
 
A

Andi Mayer

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
 
B

Billy

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
 
F

fredg

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top