Invalid date in MySQL datafow using Hubspot

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

Best Answer

  • MarkSnodgrass
    Answer ✓

    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
    
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    Answer ✓

    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
    
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • That looks like it did the trick, thanks!