Uppercase for date format

[Bill]

Is there any way to use the properties of a date/time data
type field to make the month part of a medium formatted
date appear in all uppercase characters? Any help would be
appreciated.

Thanks,
Bill

 

[Larry Linson]

Is there any way to use the
properties of a date/time data
type field to make the month
part of a medium formatted
date appear in all uppercase
characters? Any help would be
appreciated.

This works nicely for me in the Immediate Window of Access 2003 Beta 2:

? UCASE(Format(Date(),"Medium Date"))
23-SEP-03

So does this, if you prefer it:

? UCASE(Format(Date(),"mmm dd, yyyy"))
SEP 23, 2003

 

[Bill]

Larry,

Thanks for your reply. I tried your suggestion, and I can
see how it would be helpful in an expression in a query,
form, or report. But do you have a way that the format for
a date can be specified as uppercase as a table field
property?

Thanks,
Bill