Failure Reason: Provided Date Cannot Be Parsed
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?
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?