Salesforce Date Field Imports

Published: Jun 12, 2018
Post Author Written by Ethan Sorenson

Salesforce will want “Date” and “Date Time” fields to be sent in the correct format.

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”)

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.