cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I change date format used

I need to change the date format to Month/Day/ Year, so when I export into excel I can sort by date.  With the Day/Month/Year format that is the default, you cannot sort so that each month is together

Solved
Best answer 03-11-2019

Accepted Solutions
Experienced Member

Hello e.vanderiet, Let's change the date format in your Q...

Hello e.vanderiet,

Let's change the date format in your QuickBooks Online account in just a few clicks!

Here's how to:

  1. Click on the Gear icon.
  2. Click on Account and Settings.
  3. Go to Advanced.
  4. Click on the pencil icon under Other preferences, select the date format that you want to use.
  5. Click on Save under other preferences.
  6. Click on Done.

That's it! The date format set in QuickBooks will flow on your reports and exported excel file.

Let me know how you go by leaving a comment below and I'll be here to help you.

6 Comments
Experienced Member

Hello e.vanderiet, Let's change the date format in your Q...

Hello e.vanderiet,

Let's change the date format in your QuickBooks Online account in just a few clicks!

Here's how to:

  1. Click on the Gear icon.
  2. Click on Account and Settings.
  3. Go to Advanced.
  4. Click on the pencil icon under Other preferences, select the date format that you want to use.
  5. Click on Save under other preferences.
  6. Click on Done.

That's it! The date format set in QuickBooks will flow on your reports and exported excel file.

Let me know how you go by leaving a comment below and I'll be here to help you.

Active Member

Re: Hello e.vanderiet, Let's change the date format in your Q...

Hi,

 

This is great, but the options are terrible.   I have a company that sends invoices to both British and American companies.  Whichever option we choose of dd-mm-yy or mm-dd-yy will confuse one set of customers or another.  Why are there not any options that write out the month, to be acceptable to both?  And why is this a global setting, not one we can change with a different invoice template for both sides of the Atlantic?

 

Thanks

Experienced Member

Re: Hello e.vanderiet, Let's change the date format in your Q...

I concur wholeheartedly. The options are useless when we need to invoice to multiple countries. There needs to be an option with MMM for a 3 character month at the minimum. We use our own date on every line entry of an invoice to get around the problem but the Invoice date and ageing date are still in this useless dd-mm-yyyy or mm-dd-yyyy format. We have to keep changing the preference before sending the invoice to each country.

Highlighted
QuickBooks Team

Re: Hello e.vanderiet, Let's change the date format in your Q...

Thanks for your feedback about the date format in QuickBooks, spiderman789 and Andrew_Hertford.

 

While getting more options for the date format is unavailable, you can go back to the Other Preferences window and change it manually.

 

I will share your suggestions with our product engineers for review. They'll take a look at them and check if they can add it for future updates. 

 

We're always here to help anytime you have questions with Quickbooks.

Experienced Member

Re: Hello e.vanderiet, Let's change the date format in your Q...

We wouldn't need 2 separate formats if you would just make an option available with MMM for month instead of MM, ie. 20-Apr-2019 or Apr-20 2019. It would remove confusion completely for all countries. Such a simple change to remove an obvious ambiguity.

Experienced Member

Re: Hello e.vanderiet, Let's change the date format in your Q...

Would appreciate if this feature was added also.