I'm trying to bring in data from Mailchimp but when I connect the API it tells me "(Connector error: String '-001-11-30T00:00:00+00:00' was not recognized as a valid DateTime.)":
I know the problem is coming from "send_time" as when I take this out I have no issues. I have tried to exclude the string from the SELECT statement but I get another error message saying that it could not parse the SELECT statement.