Crystal 2008 & SQL

[Former Member]

I am creating a report using Crystal Reports 2008 connecting via ODBC to a SQL database. All of my fields are coming across correctly with exception of "Scheduled_Date", according to the Field Explorer in Crystal, it shows my field with a Field Type of "Number". How can I change this in Crystal to a Date so it will display properly. I can not make any changes in the SQL database as it is proprietary.

Help, I am new to Crystal reports.

Thanks,

Tom

[Former Member · Accepted solution]

Hi Thomas

In order to change the field type to date, create a formula as:

date()

and then use this formula in the designer.

Hope this helps!

Thanks

Poonam Thorat

[Former Member]

Thomas,

U said that Scheduled_date field type is number. If u disply the filed in the report which format it is displayed.

What i mean is for today it displays like 10102008 or something else.

Because it can't be shown as 10/010/2008 which is a non-numeric.

Just let me know.

thanks