Dates from SQL db

Hi,

I have a report with an SQL db datasource with date types DATE, these show in the report as strings instead of dates.  How can I solve this without having to use formulas ?

Thank you

When you say SQL db are you meaning MS-SQL db?  If so, I have never seen this behavior.  What version of Crystal Reports are you using and what is the version of the DB and how are you connecting to the DB?

I usually cast them to Datetime in the select criteria