How can I force capitalization in a custom date format in Access?

[Guest]

The Federal Aviation Administration requires a specific date format on
certain forms we complete. In the format required 12/10/04 needs to be
displayed as DEC 10, 2004. With the field set as a Now() type date field
and the date format as mmm dd"," yyyy I can't find a way to force the month
designation to capital letters.

 

[fredg]

The Federal Aviation Administration requires a specific date format on
certain forms we complete. In the format required 12/10/04 needs to be
displayed as DEC 10, 2004. With the field set as a Now() type date field
and the date format as mmm dd"," yyyy I can't find a way to force the month
designation to capital letters.

Use an expression.
If you are not displaying the time portion, why do you need Now()?

=UCase(Format(Date(),"mmm dd"", ""yyyy"))

You can substitute Now() for Date() if you must.

 

[Guest]

fredg...Thanks!! works great...

Use an expression.
If you are not displaying the time portion, why do you need Now()?

=UCase(Format(Date(),"mmm dd"", ""yyyy"))

You can substitute Now() for Date() if you must.

 

[John Vinson]

The Federal Aviation Administration requires a specific date format on
certain forms we complete. In the format required 12/10/04 needs to be
displayed as DEC 10, 2004. With the field set as a Now() type date field
and the date format as mmm dd"," yyyy I can't find a way to force the month
designation to capital letters.

Kludgy but it works:

UCase(Format([datefield], "mmm dd\, yyyy"))

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

The Federal Aviation Administration requires a specific date format on
certain forms we complete. In the format required 12/10/04 needs to be
displayed as DEC 10, 2004. With the field set as a Now() type date field
and the date format as mmm dd"," yyyy I can't find a way to force the month
designation to capital letters.

Kludgy but it works:

UCase(Format([datefield], "mmm dd\, yyyy"))

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Could a date field in the db be formatted on a report such that it would display in the same manner?