Data data type in crystal report

[Former Member]

Hello,

I have an SP which creates a temp table in SQL then returns the data in that table. One of the column in that temp table is date data type. I created a crystal report and used that SP as a  data source. Under the database field in crystal report, the column is defined as string[10]. how come it is not saying date data type instead of string[10]. why is crystal considering as a string data type instead of date data type.

Thanks.

[DellSC · Accepted solution]

What type of database are you connecting to and what type of connect are you using (ODBC, OleDB, native, etc.)

-Dell

[Former Member · Accepted solution]

Hi Dell,

I am connecting to SQL server database using OLE DB for SQL Server.

[DellSC · Accepted solution]

It may be because it's a Date datatype instead of a DateTime datatype.  Is there something you need to do with the field where you need it as a non-string type?  You could always convert it to a date in a formula if you need to.

-Dell

[Former Member · Accepted solution]

Oh,

so it is because data datatype instead of a datetime datatype. I see. I thought crystal recognizes date datatype. That's all what I needed to know. thanks for your help.