Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal 2008 & SQL

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

replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question