NIC PLI Error & Solutions

If you have error (while uploading CSV file by NIC PLI Bridge) as "STRING IS NOT RECOGNIZED AS A VALID DATE TIME" then change the date values (In the csv you can find the date as 19-MAR-2010 change it as 19-3-2010 )by selecting the column and Format cells -> Number -> Category:Date -> and type as *14/03/2001.And then try to upload the file and your problem will be solved.Copy of d023042010.csv -> Unchanged and Original downloaded file from PLI site.d023042010.csv -> Date type Changed file.NIC PLI error.jpeg -> Screen shot of the error.