Report export to Excel Date Errors

[SMcGoldrick]

When exporting reports to Excel the date field does not match that of the date entered in Hubspot.  In reporting, the format view Month/Year and then when exported it reflects the first date of the month instead of the actual date entered on the record.  This is causing a gap with leveraging reporting as support to our internal invoice processes for handoffs.

[karstenkoehler · Accepted solution]

Hi @SMcGoldrick,

Could you give a few examples / share screenshots? It sounds like your region settings in Excel might be causing this, not necessarily the raw data.

Best regards

[SMcGoldrick]

Thank you for the suggestion, I located that area and made an adjustment to my short date in Advance Settings and seems to help for the most part.  It works but not captured on the HubSpot Export Summary tab, only reflected on the 2nd tab titled the same as the report on the platform.