SalesForce Date Field Imports
Tuesday, June 12, 2018
SalesForce will want “Date” and “Date Time” fields to be sent in the correct format.
return DateTime.Now.ToString(“yyyy-MM-ddThh:mm:ss”)
return Convert.ToDateTime(_SOURCEFIELD).ToString(“yyyy-MM-dd”)
return Convert.ToDateTime(_SOURCEFIELD).ToString(“yyyy-MM-ddThh:mm:ss”)
SalesForce “Date” acceptable format
- yyyy-MM-dd
- yyyy-MM-ddThh:mm:ss
SalesForce “Date Time” acceptable format
- yyyy-MM-ddThh:mm:ss
Example conversion scripts
return DateTime.Now.ToString(“yyyy-MM-dd”)return DateTime.Now.ToString(“yyyy-MM-ddThh:mm:ss”)
return Convert.ToDateTime(_SOURCEFIELD).ToString(“yyyy-MM-dd”)
return Convert.ToDateTime(_SOURCEFIELD).ToString(“yyyy-MM-ddThh:mm:ss”)
