Question about Intuit QuickBooks Premier: Accountant Edition 2003 (275957) for PC

1 Answer

Date format in quickbooks 7.4

Would like to change date format from mm/dd/yyyy to dd/mm/yyyy

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 16 Answers
Re: Date format in quickbooks 7.4

If it's anything like Excel, someplace in the FORMAT menu should be options to allow you to change the date format. (Block off the cells, row, or column in question, click FORMAT in your toolbar.) You may have different country options or formatting choices within the date type.

Posted on Nov 19, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

Quickbooks point of sale date format

According to Intuit QuickBooks formats dates the same way that Windows does. To change the format of dates in QuickBooks, change your settings in Windows you are using. For more help in changing date format in window's follow Intuit Support .

Apr 01, 2014 | Intuit QuickBooks Point of Sale Pro...

1 Answer

SQL query to change date and/or time format

The function you're probably looking for is CONVERT. Here's an example (101 applies the format "mm/dd/yyyy", 108 applies "hh:nn:ss"):

SELECT CONVERT(varchar(10),getdate(),101) as JustDate, CONVERT(varchar(8), getdate(), 108) as JustTime


JustDate JustTime
---------- --------
09/24/2013 13:13:56

(1 row(s) affected)

Jul 15, 2013 | Microsoft SQL Server 2005 Standard Edition

1 Answer

In quickbooks pro 2007, the date format is mm/dd/yyyy

Hi, i am using windows 7 and clicked on start, control panel, regional and language, and then found my settings (was having same problem with quickbooks premier and the date set to US) and found i had accidently selected in the install of windows 7 [English-USA] instead of [English-Australia]. i altered two settings and now my quickbooks is working fine. whenever i searched for this on quicken help sites it did not indicate clearly how easy it was to fix this.

Oct 01, 2009 | Intuit QuickBooks Premier: Accountant...

1 Answer

Excel merge to word office 2007


This might be an issue with the way you have your field set up.
Right-click on your field and select TOGGLE FIELD CODES until you can see the word "mergefield".

Assuming the name of your field is "mydatefield" , the code below should give you the required format.

{ MERGEFIELD mydatefield \@"DD/MM/YYYY" \*Mergeformat }

Good luck...

Jan 16, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Hi running word 2003 have an auto fill in the date feature installed on a fax template how do I disable it. if I open up previous documents composed the present date populates yet the document was composed...

This is caused by the document using a "field" and not an actual date. Press <ALT+F9> to see the date's field code. You will probably see: { DATE } or { DATE @ "M/d/yyyy" } (NOTE: The M/d/yyyy formatting may be different for you; since this is personal choice). You can manually delete the field and type in your date. To automate this, open the TEMPLATE (*.DOT) and change the field by using: Insert > Field... and selecting "CreateDate" from the Field names list. Also - set your desired format too and then click <OK>. Save the change to your template and it will use the date you create the fax and keep that date if the fax is saved as a document and reopened in the future.

Jan 11, 2009 | Microsoft Word 2003 for PC

1 Answer

Need to Add Dates in Excel

Here is one way I just tried:

Say the date purchased is in A1.

You want the Est Life in A2.

In A2 type: =A1+(3*365)
That will add 3 years.

For 5 years: =A1+(5*365)

Try it out!

Note: You will need to format the cells to Custom>mm/dd/yyyy

Nov 21, 2008 | Microsoft Excel for PC

1 Answer

How to calculate total downtime of a perticulor ticket. for ex: if a perticulor ticket being opened three days before and the end time would be 4th or 5th day, so the ticket details would be containing,...

cell 1 = logged in date <mm/dd/yy>
cell 2 = logged in time <hh:mm:ss>
cell 3 = resolved date <mm/dd/yy>
cell 4 = resolved time <hh:mm:ss>
cell 5 = cell 4 + cell 3 - cell 2 - cell 1 <general format>
cell 6 = day(cell 5) <general format>
cell 7 = hour(cell 5)&":"&minute(cell 5)&":"&second(cell 5) <general format>

Nov 18, 2008 | Business & Productivity Software

1 Answer

Microsoft Access Query

Your date form is what it wrong. In order to use dates in Access with a BETWEEN function clause the values have to specifically be dates.

You can create dates in literal strings using the # sign to bound them, as in:

Select DISTINCT [ActivityDate] between #1/1/08# and #12/31/08#

#....# tells Access to treat this literal string as a date.

If you are using non-literal values, such as a parameter handed into the query, which would then be a variable, you can't use #some_variable# to cause Access to view it as a Date since #...# is for literal values only. To convert (also called "casting" a variable), use the CDate function. CDate likes to know what format to expect the string to come in though so it helps to pass that along, as in:

Select DISTINCT [ActivityDate] between CDate(begin_dt_string) and CDate(end_dt_string)

Remember the date string you pass into CDate has to be readable as a date by CDate. So make sure you pass in something that it can handle (use the IsDate() function to check to be sure so you can avoid a runtime datatype casting error). If your locale is US, then passing in x/y/z it will take for MM/DD/YYYY. If Europe, it will take it as DD/MM/YYYY. So keep that in mind.

To convert out of a date, use the FORMAT() function. That is how you get a date data type value to become a string value.

More fun reading:

Hope this helps!

Feb 11, 2008 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Help me..

It needs to be in the format "yyyy-dd-mm hh:mm:ss:nnn". The BETWEEN keyword must include the time as well. so if you want from DTPicker date of "2007-09-01" and "2007-09-10" it will literally be this "2007-09-01 00:00:00.000" and "2007-09-10 00:00:00.000" thus not including any of the day for the 10th. If you want the 10th, then you have increase Date2 + 1 day to be "2007-09-11 00:00:00.000".

You should always remember that dates include the time.

I like to use the >= date1 and < date2. It's a little more forgiving.

Sep 24, 2007 | Microsoft SQL Server Standard Edition for...

Not finding what you are looking for?
Intuit QuickBooks Premier: Accountant Edition 2003 (275957) for PC Logo

Related Topics:

990 people viewed this question

Ask a Question

Usually answered in minutes!

Top Intuit Business & Productivity Software Experts

Mark Taylor
Mark Taylor

Level 3 Expert

728 Answers


Level 3 Expert

4327 Answers

Cindy Wells

Level 3 Expert

4721 Answers

Are you an Intuit Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides