Jet Date Problem

[jlparise]

I'm having an issue with the JET provider and my CSV file.

Basically the issue is that occasionally the date stamp is read in wrong by the provider. For example

Sometimes 12/12/2007 is read in as 2/12/2007. This is always the pattern the first digit of the month is missing and everything else is fine.

However, this does not happen to all the records, some of them are read in intack.

Anyone have any thoughts/tips?

Thanks,

Jon

[Torgg]

I just posted to another question about csv files and I tested your date problem in my csv parser. I didn't have any problems with the data at all. Without seeing your code/data I'm going to point you to the other post on this forum http://www.thescripts.com/forum/thread755637.html

I hope you find it helpful,
Torgg