Uppercase for date format

  • Thread starter Thread starter Bill
  • Start date Start date
B

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
 
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.
Click to expand...

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
 
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
 
Back
Top