Invalid date in MySQL datafow using Hubspot

user07053

Hey there, I'm attempting to join HubSpot data with another datasource using a MySQL dataflow but running into an error.

In the HubSpot dataset, the closedate field is recognized as a timestamp, and looks great. In the data preview it filters correctly.

When I add the HubSpot data to a MySQL dataflow, the column previews as "Invalid Date" and the joins I'm trying to do based on date fail.

Any tips??

MarkSnodgrass

Have you tried wrapping the DATE() function around your column in your MySQL dataflow to force it to be a date column?

SELECT DATE(`last_update`)
FROM

user07053

That looks like it did the trick, thanks!