Date Upper Case

V

Vinnie

I would like the Date to be Capitilized in my Reports.

Meduim Date Field (10 May 06).....Would like it to read (10 MAY 06).
I can get it in a text field, but how do you do it in a Date/Time Field?

Appreciate any help.

Vinnie
 
R

Rick Brandt

Vinnie said:
I would like the Date to be Capitilized in my Reports.

Meduim Date Field (10 May 06).....Would like it to read (10 MAY 06).
I can get it in a text field, but how do you do it in a Date/Time
Field?
Appreciate any help.

Vinnie
Click to expand...

=UCase(Format([DateField],"dd mmm yy"))
 
V

Vinnie

LoL.

Thanks!


Rick Brandt said:
Vinnie said:
I would like the Date to be Capitilized in my Reports.

Meduim Date Field (10 May 06).....Would like it to read (10 MAY 06).
I can get it in a text field, but how do you do it in a Date/Time
Field?
Appreciate any help.

Vinnie
Click to expand...

=UCase(Format([DateField],"dd mmm yy"))
Click to expand...
 
Top