Clay Icon

Issue Updating Date Field in SFDC Despite Correct Format

·
·

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.

  • Avatar of Channeled
    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

  • Avatar of Petra H.
    Petra H.
    ·
    ·

    nope

  • Avatar of Channeled
    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

  • Avatar of Petra H.
    Petra H.
    ·
    ·

    none of these apply to me

  • Avatar of Channeled
    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!

  • Avatar of Petra H.
    Petra H.
    ·
    ·

    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.

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    Hey Petra, thanks for reaching out! Glad to hear you solved this!! :) Let us know if you have any other questions. :)

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Petra H.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Petra H.
    Petra H.
    ·
    ·

    Actually not solved Owen L.. The date is not being updated on SFDC, because the column is erroring once converted to number. Need help please

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    Got it, do you mind sharing the URL to the table where this is occurring? Would love to take a closer look! :)