Thursday, October 06, 2011

Salesforce - Data Loader Date Format

When loading data via Apex Data Loader, we sometimes find errors due to wrong date formats or the data is uploaded but the date is not the one expected.

Date format for salesforce : yyyy-mm-ddThh:mm:ss.ssZ


Applying the date format in Excel.


Step 1: Select dates in the excel and righclick and choose "Format Cells..."


Step 2: In the Number Tab, choose 'Custom'
 


Step 3: Paste the Date Format "yyyy-mm-ddThh:mm:ss.ssZ"

Step 4: Click Ok. Format of date changes