Fix HubSpot date format errors before import

Mixed date formats can block imports or silently corrupt date values in HubSpot. TidyImports flags invalid date cells and helps you normalize values before upload.

Why date formats cause import problems

• HubSpot expects dates in a specific format — mixing MM/DD/YYYY and DD/MM/YYYY in the same file leads to silent misinterpretation.
• Invalid date strings (e.g. Jan 5th) are often ignored or cause row-level errors.
• Date columns exported from different tools often arrive in different formats.

What to normalize before import

• Pick one date format and apply it to all rows.
• Remove ambiguous values like 1/2/2025 where month/day order is unclear.
• Check for date-like values in non-date columns (cleanup artifacts).