Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
community Alteryx Academy MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Error SQLFetch: [Amazon][Support] (40481) Invalid data format for '17-05-24'.

lindbergh
7 - Meteor
‎06-02-2017 04:12 PM

Attempting to pull data from Amazon Redshift and ran into the following error. The workflow previously worked.

 

2017-06-02_16-09-48.png

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
lindbergh
7 - Meteor
‎06-05-2017 01:15 AM
The issue was with the data. Someone put "0017" as the year.
Reply
mattagone
7 - Meteor
‎09-24-2018 06:38 AM

I'm having a similar issue but I don't have write access to the source data. I'd also love to be able to solve this without unchecking the header box, bringing everything in as Vstrings and having to rename a few dozen columns. 

Reply
0 Likes
Labels
Top Solution Authors
View All