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

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 d开发者_开发知识库ates?

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