Why does Crystal change my string data to a date

[Almie]

I am using Crystal 10, pulling from a Informix database.

The field type is a string, the data in the record is "3-2007". When the records display in Crystal, it is displaying "Mar-13".

HOw can I make the data display "3-2007" which is what is stored in the table record?

 

[Almie]

Also, the field needs to stay a string because other data records have character in them like, "20-1234A

 

[dgillz]

So how does the record display when the value is "20-1234A"?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry