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
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 4: Click Ok. Format of date changes
1 comment:
Indeed a lifesaver! :P
Post a Comment