Crystal 9.0, Windows XP and a .txt file

[Goosetown]

Hello all,
I'm writing a report based upon a '|' delimited text file (.txt). I've defined my ODBC data source and I have defined a field as a date type field. In the .txt file the data looks like '043004'. However, when I use this field on my Crystal report it will not pull anything at all. If I change the attributes of this field and turn it into a 'Char' type field, I can get data to my report. But then if I try and use this field in a formula to convert it to a date, I get 'Bad Date Format String' errors. I've checked all the data and every field is in the same format 043004 or 050104. They all appear to be date fields.

Now this is where this gets odd, I can do the above mentioned on Win2000 with Crystal 9.0 perfectly. It acts as expected. But when I move this to the site's pc which is WIN XP it blows up.

Is this a Crystal issue or could it be an issue of XP and the Microsoft Text Driver?

Thanks for any help. This is a great forum!

 

[Goosetown]

Whoops, sorry for any confusion but this is happening on Win2000 also. I had my ODBC driver pointing to a wrong field.

 

[Goosetown]

Figured it out. It's not Crystal nor WinXP but it is the format of the date field within the .txt file. When we changed the format to 04/30/04 it worked great.

Sorry for the bad post.