# Dates from spreadsheet are not sent to Saleforce

**URL:** <https://community.parabola.io/t/dates-from-spreadsheet-are-not-sent-to-saleforce/1961>\
**Category:** Ask a question\
**Tags:** Building-Flows\
**Created:** [August 6, 2021, 6:01am UTC](https://community.parabola.io/t/dates-from-spreadsheet-are-not-sent-to-saleforce/1961 "2021-08-06T06:01:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gerardo](https://avatars.discourse-cdn.com/v4/letter/g/4af34b/32.png) [@Gerardo](https://community.parabola.io/u/Gerardo)\
**Post date:** [August 6, 2021, 6:01am UTC](https://community.parabola.io/t/dates-from-spreadsheet-are-not-sent-to-saleforce/1961/1 "2021-08-06T06:01:27Z")

</div>

Hello! I am currently stuck in a flow that is supposed to send data from a spreadsheet into salesforce. The format is exactly the same as in Salesforce; however, Salesforce keeps ignoring any row that has dates in there. Am I missing something?

![image](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/4/48f0b69fc260cec4ce24cb0fb28c562d91410097.png)

---

<div class="post-metadata">

**Author:** ![Adam\_R](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/adam_r/32/2207_2.png) [@Adam\_R](https://community.parabola.io/u/Adam_R)\
**Post date:** [August 6, 2021, 4:25pm UTC](https://community.parabola.io/t/dates-from-spreadsheet-are-not-sent-to-saleforce/1961/2 "2021-08-06T16:25:39Z")

</div>

Hey @Gerardo,

Sorry to hear that you’re hitting this error! As a first attempt to troubleshoot, let’s try using the “Format Dates” step, converting the date format from “Auto-Detect” to the custom date format “M/D/YYYY”. This will ensure that all values in the date column are properly in your current date format.

If still no success, let’s try changing the date format to “yyyy-MM-dd,” per the guidance in [Salesforce’s API docs](https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/datafiles_date_format.htm). Let me know if either of these approaches does the trick!

---

<div class="post-metadata">

**Author:** ![Gerardo](https://avatars.discourse-cdn.com/v4/letter/g/4af34b/32.png) [@Gerardo](https://community.parabola.io/u/Gerardo)\
**Post date:** [August 6, 2021, 5:01pm UTC](https://community.parabola.io/t/dates-from-spreadsheet-are-not-sent-to-saleforce/1961/3 "2021-08-06T17:01:11Z")

</div>

Hello, Adam! Thank you for your quick reply. The solution was to change the dates to the YYYY-MM-DD format. Thank you for your help!