How do I get a Date from SQL Server in Crystal Reports 11?

Question

I have a stored procedure that selects from a table, two of the fields are DATE type in SQL Server, but when I select the stored procedure from Crystal Reports, the two date fields appear as Strings (in the YYYY-MM-DD format). I could write formulas to convert these to the MM/DD/YYYY output that is expected for this report, but is there not a way to get Crystal to recognize SQL Server dates?

Answer 1

yes, write formulas, YYYY-MMM-DD is the representation of a date.