Dashboards & Reporting

SMcGoldrick
Contributeur

Report export to Excel Date Errors

Résolue

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 Votes
1 Solution acceptée
karstenkoehler
Solution
Au panthéon de la communauté | Partenaire solutions
Au panthéon de la communauté | Partenaire solutions

Report export to Excel Date Errors

Résolue

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.

Voir la solution dans l'envoi d'origine

2 Réponses
karstenkoehler
Solution
Au panthéon de la communauté | Partenaire solutions
Au panthéon de la communauté | Partenaire solutions

Report export to Excel Date Errors

Résolue

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
Contributeur

Report export to Excel Date Errors

Résolue

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 Votes