Date field format

[nysouth]

Am am sure there is a simple solution, but I have just been hitting a brick wall.

I am using Crystal 8.5 have a problem with getting dates to appear as they need to. The date field in my database is a date/time field. When I go to change the format of this date, the option I need is not there. I would like the date to show like this:

March 8, 2003

but the only option is March 08,2003, which looks really strange on letters.

I tried clicking on customize and it has a place to change from the day where the 0 is not included, which I do and click OK, but nothing happens.

What am I missing?

 

[Madawc]

I'm surprised that customising isn't working for you. But as a work-round, you could create a formula field and use ToText. Something like
totext ({your.date}, "MMMM d, yyyy&quot

Madawc Williams
East Anglia, Great Britain