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

=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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top