Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem with SQL date type field

Hi, I just moved to SQL Server 2008 and one of my fields is a 'date' type. The data shows as "YYYY_MM_DD". When I add this field to my Crystal Report it does not show up as a date. I am using Crystal Reports XI R2. I tried to use the Date function with it but it gives me an error "Bad Date Format String". Is this a bug in Crystal? What is the best way for me to get my date formatted in mm/dd/yyyy?

Thanks,

Former Member
Not what you were looking for? View more on this topic or Ask a question