I have an application which imports data into our CRM deployment from a series of CSV files extracted from an other SQL database. This has worked fine until I added a new csv file that includes a date in the import string. When I try importing
programmatically that import fails, but if I use the import wizard on the same file it imports ok. If I remove the date from the csv the file imports ok programmatically, so I have clearly identified the problem. By default the dates are formatted
dd/mm/yyyy, however I have tried mm/dd/yyyy and yyyy-mm-dd:T00:00:00 as well. The date is " delimited in my file.
Am I missing a trick somewhere? Any help would be appreciated.
John