cancel
Showing results for 
Search instead for 
Did you mean: 
grishsavla
Level 1

Reports which are exported in excel has the below issue. The dates are not in the date format. The data is stored as General format and does not change properly to dates

 
9 Comments 9
SarahannC
Moderator

Reports which are exported in excel has the below issue. The dates are not in the date format. The data is stored as General format and does not change properly to dates

Hello there, grishsavla.

 

We can fix the incorrect report by enabling Marcos. Here's how:

 

  1. In Excel, go to the File menu.
  2. Select Options.
  3. Click Trust Center, then select Trust Center Settings.
  4. Select Macros Settings, then select Disable all macros except digitally signed macros.
  5. Select OK.
  6. Re-export the report from QuickBooks Online to Excel.

 

If your customer gets a notification about Macros when exporting, accept the Macros. You can also check this article to learn on what to do when there are missing details when opening the report in Excel. Then, here are some articles that will guide you through modifying and memorizing reports within your QBO account.

 

 

Please don't hesitate to post again if you have other questions. I'm here to help. Take care always.

irenemkm79
Level 1

Reports which are exported in excel has the below issue. The dates are not in the date format. The data is stored as General format and does not change properly to dates

Hi!

I did what you explained but still it is not working. When I export to excel the dates are not in dates format, I try to change but it doesn't work. Of course, when I try to short by date that column it doesn't do either. Could you help please? 

JessT
QuickBooks Team

Reports which are exported in excel has the below issue. The dates are not in the date format. The data is stored as General format and does not change properly to dates

Hi irenemkm79,

 

Thank you for trying the steps shared by Sarah.

 

It would be best to contact our Chat Support team. That way, they can start a screen-sharing to gather more details and investigate this further. They have more tools on their end.

 

If you have other questions, feel free to go back to this thread.

Gulraiz
Level 2

Reports which are exported in excel has the below issue. The dates are not in the date format. The data is stored as General format and does not change properly to dates

I am sorry...so is there a solution readily available or is it not invented yet? coz I have a similar struggle still trying. If anyone knows please share. 

AbegailS_
QuickBooks Team

Reports which are exported in excel has the below issue. The dates are not in the date format. The data is stored as General format and does not change properly to dates

Hi there, @Gulraiz

 

I understand how important  to manage your report in doing business.

 

To further assist you, I'll ensure you'll be routed to the right support. In that way, they can check why you're experiencing this kind of error.

 

Here's how to contact them:

  1. Go to the Help menu on the top right and click Contact Us
  2. Type your concern in the box, then tap Let's talk
  3. Click Chat and complete the required information. 

 

You can check our support hours to ensure we can address your concern immediately.

 

Feel free to visit our QuickBooks India Community. This page contains a lot of questions about handling your business transactions, reports, and other topics.

 

Don't hesitate to click the Reply button to post a comment or to let me know how the chat goes. I'm always here, willing to assist you. Keep safe.  

Masha1
Level 1

Reports which are exported in excel has the below issue. The dates are not in the date format. The data is stored as General format and does not change properly to dates

Hi  @AbegailS_ and the rest of QuickBooks team

I am having the same issue with my QB.

As suggested, I have contacted the QuickBooks team and they do not have a solution for this problem. 

If anyone found out how to fix the issue, please let me know. I am also open to a phone call from anyone from QuickBooks team to show me a solution. 

As off right now- QuickBooks team's Suggestion is to "retype each date" which is laughable. 

 

Thank you

Charlie_K
Level 1

Reports which are exported in excel has the below issue. The dates are not in the date format. The data is stored as General format and does not change properly to dates

Hi @Masha1 

 

I'm creating a new column next to date column in Excel. I use function =Datevalue and click the column where the dates are from the QBO export. This converts General/Text type into date format. At least this worked for me and I was able to group dates again in pivots etc.. 

 

 

Masha1
Level 1

Reports which are exported in excel has the below issue. The dates are not in the date format. The data is stored as General format and does not change properly to dates

Thank you, Charlie. That worked!

 

irenemkm79
Level 1

Reports which are exported in excel has the below issue. The dates are not in the date format. The data is stored as General format and does not change properly to dates

Thank you! It also worked for me :)