Format of Field

[Novice1]

I have a date field that I need to show as follows: 12SEP05 (no spaces, month in caps). I changed the format of the field to ddMMMYY. The field shows as 12Sep05. I cannot capitalize the month. I tried inserting ">" without the quotes but without luck. Any help would be appreciated.

 

[Crispy]

OK - this is how I got it to work. There may be better ways...

Put a new textbox on your report. Set the Data Source to:

=Day([YourFieldName]) & UCase(MonthName(Month([YourFieldName]),-1)) & Year([YourFieldName])

HTH

Chris

 

[Novice1]

Chris,

Almost ... the result is 17SEP2005. How do I show an abbreviated year (17SEP05). Thanks

 

[Crispy]

This should do it

=Day([f3]) & UCase(MonthName(Month([f3]),-1)) & Right(Year([f3]),2)

 

[Crispy]

In the above expression, F3 represents your field name

 

[Novice1]

It Works

I thank you. My staff thanks you and my mother thanks you.