Date Recognition

[Former Member]

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 · Accepted solution]

Hi

You can write a function to convert this within crystal to date or datetime. Is this passed as a parameter to Crystal?

Regards

Dotun

[Former Member · Accepted solution]

Hi, It is not a parameter. Just a field on a database. All the date fields are like this. I think I should be able to make Crystal recognize them as date fields without writing a formula. I would not want to write a formula for every date field in the database or even have to apply anything each time I use a date. Regards, Kathleen

[Former Member · Accepted solution]

Hi,

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.

Regards

Dotun

[Former Member · Accepted solution]

Thanks, but I am really looking for a way to make Crystal aotuomatically recognize a field as a date field when it is a date field and in a defined date format.