There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Cannot convert value "(PDH-CSV 4.0) (E. Australia Standard Time)(-600)" to type "System.DateTime". Error: "String was not recognized as a valid DateTime."
I am having a problem when I try to run PAL against CSV files that contain date time as:
It appears that the date entry causes the issue. Similar CSV files that do not have the date range of 04/01/2012 - 04/12/2012 are fine. It seems PAL thinks the date range is for 04th january through 04th December, rather than 1st April through to 12th of April.
This issue is occurring on a number of servers at different sites.
I am uploading two CSV files produced in a similar fashion, but covering different dates. One works and the other fails when parsing through PAL.
Any help on modifying the date column is greatly appreciated.