Skip to Content

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

Date Recognition

Hello, The data I am connecting to has the dates in the format DDMmmYYYY, i.e. 16Oct2008. Crystal is not recognizing this as a date. On the options menu under date the style selected is System Default Long Format and displays the sample as 01Mar1999. On field explorer the dates are recognized as string 255. How can I get Crystal to recognize these as dates? Thank you.

Former Member
Former Member replied


A solution is to convert within the database for crystal to see in the right format. I just did this on MSSQL

Select convert(VARCHAR,datefield,120)

However, there may be some other solutions but I have used this before and it worked.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question