Formatting a Date in an Expression

[S Jackson]

Okay, this has bugged me for a long time and I know there is a way to get
this the way I want.

I have a text box on a report. The Control Source is:

="LTCR CASE HEARINGS AS OF" & Date()

However, the report displays the date as 11/21/03 instead of written out in
full: NOVEMBER 21, 2003 (note I want the month to be all caps too). How do
I format the date when there is text in front of it. I tried changing the
format properties of the text box control but that doesn't work.

TIA
S. Jackson

 

[Joe]

Try:

"LTCR CASE HEARINGS AS OF " & UCase(MonthName(DatePart
("m", Date()), False)) & " " & DatePart("d", Date())
& ", " & DatePart("yyyy", Date())

Sometimes you have to rip the date apart and put it back
together.

 

[S. Jackson]

Kewl! I'll give it a try. Thanks for your response.

S. Jackson