Re: SQL and Crystal Dates
Have you made the SQL fields DateTime? CR doesn't like Date & DateTime2. At best, it treats them as strings.
And - are you converting dates? Tran.Billdate may be giving you problems.
Re: SQL and Crystal Dates
We did a straight conversion with no changes to the date fields. What do you mean by "converting dates"?
Re: SQL and Crystal Dates
XI does not understand anything other than DateTime. If the conversion to SQL converted DF Dates to SQL Date fields, no go with XI.
XI was written before MS added Date & DateTime2 fields to the DB.
Re: SQL and Crystal Dates
In your MSSQLDRV.INT put the following setting:
[CODE]; MAP_DFDATE_TO_SQLTYPE: The SQL Server type when creating new DF_DATE columns
; Allowed values:
; date
; datetime
MAP_DFDATE_TO_SQLTYPE datetime
[/CODE]
When you convert again with this setting DF_Date columns will be created as datetime on the SQL table. On the DataFlex side it will still be a DF_DATE column.
Crystal will handle the SQL datetime properly.
Re: SQL and Crystal Dates
Where is the MSSQLDRV.INT?
Re: SQL and Crystal Dates