Crystal Report 2008 1

[jchewsmith]

How can you convert all date time fields to date for the entire report.

Crystal 8.5 used to have the option in file, report options, then a drop down to select convert date time to: date, to string or date time.

 

[pmax9999]

In 2008 it seems this this can only be set at the Global level, ie it will affect all reports.

The setting is in: File => Options => Fields => Date and Time. On the Date and Time tab, click on the Customize button and select Date from the Order drop down list.

If you don't want it to affect all reports, I think you will need to manually format every Date/Time field.

Cheers
Pete

 

[Madawc]

Don't forget the Format Brush - once you have one field set as you want it, impose the same on another field.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[pmax9999]

Madawc's suggestion is a great way to do it. To reformat multiple fields, format one of the Date/Time fields to a Date and then with that field selected from the report canvas click on the Format Painter (Brush) icon, hold down the Alt key and click on all of the other Date/Time fields that you want changed to show Date only.

Hope this helps.

Cheers
Pete