Issue Updating Date Field in SFDC Despite Correct Format

Petra · 2025-01-23 13:47:33.72661+00

Not able to update a date field on SFDC eventhough I have the correct date format. Any thoughts on what's happening here? The issue is 100% the date because when i remove it, the column works properly.

Issue Updating Date Field in SFDC Despite Correct Format | Clay

10 comments

· Sorted by Oldest

Channeled
APP
·
·
For Salesforce date fields, you'll need to ensure your dates follow these specific formats: For Date fields: ** Use the format: YYYY-MM-DDFor DateTime fields: ** Use the format: YYYY-MM-DDThh:mm:ss[Z | ±hh:mm] ** You can specify UTC using 'Z' (e.g., 2024-01-01T12:00:00Z) ** Or include a timezone offset (e.g., 2024-01-01T09:00:00-08:00)If you're still having issues, you can use Clay's Format Date/Time action to transform your date into the correct format before updating Salesforce. This will help ensure compatibility between the systems. Sources: Clay formatters overview | Documentation | Clay University Salesforce integration overview | Documentation | Clay University
Petra
·
·
nope
Loading attachments
Channeled
APP
·
·
When updating date fields in Salesforce, there are a few key things to check: 1. Make sure you're using the exact required format: • For Date fields: YYYY-MM-DD • For DateTime fields: YYYY-MM-DDThh:mm:ss[Z | ±hh:mm] 2. Check if the "Remove Blank Values" option is enabled in your Update Record action. If it's turned on, blank values won't be sent to Salesforce, which might prevent updates. 3. Verify that: • You have the correct Record ID • You've selected the right Salesforce Object • The field mappings are properly configuredIf you're still experiencing issues after checking these points, you may want to explicitly request human support for further troubleshooting. Sources: Salesforce integration overview | Documentation | Clay University Salesforce [Clay 101] - Clay University
Petra
·
·
none of these apply to me
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Petra
·
·
Solved it ✅ The problem was that the date formula was outputting as text, so I had to change the column type to Number, so that SFDC is able to deseralize it.
owen (Clay)
·
·
Hey Petra, thanks for reaching out! Glad to hear you solved this!! :) Let us know if you have any other questions. :)
Channeled
APP
·
·
Hi Petra! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Petra
·
·
Actually not solved Owen. The date is not being updated on SFDC, because the column is erroring once converted to number. Need help please
owen (Clay)
·
·
Got it, do you mind sharing the URL to the table where this is occurring? Would love to take a closer look! :)

Channeled
APP
·
·
For Salesforce date fields, you'll need to ensure your dates follow these specific formats: For Date fields: ** Use the format: YYYY-MM-DDFor DateTime fields: ** Use the format: YYYY-MM-DDThh:mm:ss[Z | ±hh:mm] ** You can specify UTC using 'Z' (e.g., 2024-01-01T12:00:00Z) ** Or include a timezone offset (e.g., 2024-01-01T09:00:00-08:00)If you're still having issues, you can use Clay's Format Date/Time action to transform your date into the correct format before updating Salesforce. This will help ensure compatibility between the systems. Sources: Clay formatters overview | Documentation | Clay University Salesforce integration overview | Documentation | Clay University
Petra
·
·
nope
Loading attachments
Channeled
APP
·
·
When updating date fields in Salesforce, there are a few key things to check: 1. Make sure you're using the exact required format: • For Date fields: YYYY-MM-DD • For DateTime fields: YYYY-MM-DDThh:mm:ss[Z | ±hh:mm] 2. Check if the "Remove Blank Values" option is enabled in your Update Record action. If it's turned on, blank values won't be sent to Salesforce, which might prevent updates. 3. Verify that: • You have the correct Record ID • You've selected the right Salesforce Object • The field mappings are properly configuredIf you're still experiencing issues after checking these points, you may want to explicitly request human support for further troubleshooting. Sources: Salesforce integration overview | Documentation | Clay University Salesforce [Clay 101] - Clay University
Petra
·
·
none of these apply to me
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Petra
·
·
Solved it ✅ The problem was that the date formula was outputting as text, so I had to change the column type to Number, so that SFDC is able to deseralize it.
owen (Clay)
·
·
Hey Petra, thanks for reaching out! Glad to hear you solved this!! :) Let us know if you have any other questions. :)
Channeled
APP
·
·
Hi Petra! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Petra
·
·
Actually not solved Owen. The date is not being updated on SFDC, because the column is erroring once converted to number. Need help please
owen (Clay)
·
·
Got it, do you mind sharing the URL to the table where this is occurring? Would love to take a closer look! :)