Date Upper Case

[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

 

[Rick Brandt]

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

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

 

[Vinnie]

LoL.

Thanks!

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

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