Skip to main content
New Idea

Failure Reason: Provided Date Cannot Be Parsed

Related products:None
  • September 20, 2017
  • 2 replies
  • 78 views
jean.nairon
ben
karen_werner
joseph_siudzinski
sarah_post
+19
  • jean.nairon
    jean.nairon
  • ben
    ben
  • karen_werner
    karen_werner
  • joseph_siudzinski
    joseph_siudzinski
  • sarah_post
    sarah_post
  • jahnavi
    jahnavi
  • narayanan_s
    narayanan_s
  • keith_mattes
    keith_mattes
  • heather_hansen
    heather_hansen
  • pele
    pele
  • darkknight
    darkknight
  • tim_van_lew
    tim_van_lew
  • greg
    greg
  • joel_peasley_285d9f
    joel_peasley_285d9f
  • melisabebchik
  • austeku
    austeku
  • gunjanm
    gunjanm
  • cankney
    cankney
  • kumaranbcak
  • badari
  • bradley
    bradley
  • JamesAllen
    JamesAllen
  • tmaggio58
  • cwherrmann

kate_green
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? 

2 replies

lakshmi_chaitanya
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

kate_green
Forum|alt.badge.img
  • Author
  • Helper ⭐️⭐️
  • 262 replies
  • September 21, 2017
No problem, I will open a ticket now.  

Thank you!

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings