formatting datetime field in formula

[hyuan]

How can I format a datetime field in a formula so the format changes from

2000/12/31 12:00am to December 31, 2000 ?

When I applied the Date() function,the result was 2000/12/31. Is there another function that will convert it to December 31, 2000?

Thanks.

 

[kenhamady]

Right-click on the field and select Format - Field.
This will give you formatting options for dates, if the field is truly date or datetime. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.