Dashboards & Reporting

SMcGoldrick
Mitwirkender/Mitwirkende

Report export to Excel Date Errors

lösung

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.

0 Upvotes
1 Akzeptierte Lösung
karstenkoehler
Lösung
Berühmtheit | Partner
Berühmtheit | Partner

Report export to Excel Date Errors

lösung

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

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

Lösung in ursprünglichem Beitrag anzeigen

2 Antworten
karstenkoehler
Lösung
Berühmtheit | Partner
Berühmtheit | Partner

Report export to Excel Date Errors

lösung

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

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

SMcGoldrick
Mitwirkender/Mitwirkende

Report export to Excel Date Errors

lösung

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.  

0 Upvotes