Customize date in report-options menu 1

[crash58]

I am attempting to format a date as Wednesday, March 1, 2003 rather than March 01. When I select all the obvious boxes, the example changes, but then when I get out to the main window, the custom format is not reflected, and of course it does not display in the report. I must have some sort of conflict going on for this not to 'hold'. Please help!

 

[IdoMillet]

Go to Insert Fields, locate the field, and select the Browse toolbar icon to see the data type and data values inside this field.

What do you see?

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[kenhamady]

Making the change in:

Report - Options

won't change a field that is already on the report. To change an existing field use:

Format - Field Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[crash58]

The field is a string field to which I've applied the cdate function. totext(CDate({Exhibitions.BeginISODate}))+" - "+totext(cdate({Exhibitions.EndISODate}))

How can I format the date from within the formula?

Thank you for your help!

 

[synapsevampire]

Try:

totext(CDate({Exhibitions.BeginISODate}),"dddd, MMMM d, yyyy&quot+" - "+totext(cdate({Exhibitions.EndISODate}),"dddd, MMMM d, yyyy&quot

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com