I am trying to upload the CSV file via Apex programming I am getting an error like Invalid Date Error. Please find the screenshot for more details. I have given code like this
site.Approved_Date__c =date.parse(inputsitevalues[13]);//date field [12].
Even though I have changed the date format as dd/mm/yyyy in CSV file I am getting the same error. Can anyone help me out in this issue.
It looks like the CSV file has the dates in mm/dd/yyyy format rather than dd/mm/yyyy. Hence the invalid date exception with the 31st month.
This will work:
date parsedDate = date.parse('31/5/2013');
This will fail with "System.TypeException: Invalid date: 5/31/2013"
date parsedDate = date.parse('5/31/2013');
From the Date.parse methods docs:
Constructs a Date from a String. The format of the String depends on the local date format. The following example works in some locales:
date mydate = date.parse('12/27/2009');
You can find the locale Date format information in the Supported Locales docs.
Another option would be to use the date format YYYY-mm-dd and date.valueOf().
One thing you can do -- Different dataloaders can pre-parse dates and manipulate them into a better format. Specifically, I believe Jitterbit's dataloader has the ability to parse multiple date formats and reset them into a Salesforce friendly way. Try looking at some of the Functions in jitterbit to see if can re-write the date on the fly.
You can use split option to parse date from csv file like below :
string[] RFQdate = String.valueOf(csvRecordData[1].trim()).split('/'); date mydate = date.valueOf(RFQdate[2] + '-' + RFQdate[0] + '-' + RFQdate[1]);
default parsing of date fields depend on settings of your locales in your org. Use this link to check your settings : https://help.salesforce.com/apex/HTViewHelpDoc?id=admin_supported_locales.htm&language=en
Thank you all for the answers. This is purely a format issue. we have interchanged the columns and keep date values far away from the end. Here, we’ve moved the columns in such a way that there are 5 more columns after dates. Now it is working perfectly with out any Invalid date issue.
