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.
A solution is to convert within the database for crystal to see in the right format. I just did this on MSSQL
However, there may be some other solutions but I have used this before and it worked.