Failure Reason: Provided Date Cannot Be Parsed

  • 2
  • Idea
  • Updated 1 year ago
When I attempt to upload data through the S3 connector that includes a Date Time field, I am met with a failure reason of, for example:

Provided date [01/19/2017 10:17 AM] cannot be parsed. at row number 19314
The field value for that row is:   1/19/2017 10:17

The upload is successful if I change the date time field to a simplified Date field, but this won't always be a suitable workaround, as sometimes there are multiple instances on the same day but at different times. 

Is there something I'm missing with regards to this data load? 
Photo of Kate Green

Kate Green, Champion

  • 5,960 Points 5k badge 2x thumb
  • unsure

Posted 1 year ago

  • 2
Photo of Lakshmi Chaitanya

Lakshmi Chaitanya, Product Manager

  • 1,724 Points 1k badge 2x thumb
Hi Kate,

The above-mentioned value is actually supported, we would need more information to figure out the issue  
Could you please raise a support ticket with attached CSV file so that we can debug the issue further

Thanks and Regards,
Lakshmi
Photo of Kate Green

Kate Green, Champion

  • 5,960 Points 5k badge 2x thumb
No problem, I will open a ticket now.  

Thank you!