SOURCE: 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.
SOURCE: Unable to Change Dates
Hi,
I am using MS-2007, i got the solution upto some level only.
i can't say exactly whether it is right or not.
my solution is :
first change the settings in ControlPanel/Regional and Language Options.
Click on Customize button/open the Date Tab and set the date format there.
and then proceed with CSV.
Open CSV in Excel and divide Text to coloumns.
Ur all Date Cells will be in particual Format.
and Select that coloumns and right click Format Celss....etc.
Thanking u.
If u found any Douts, Suggestions ,Plzz let me know.
SOURCE: oracle date functions problem
As an Oracle Developer I do not rely on default date format. You can see the default as:
SVRMGR> select * from v$NLS_PARAMETERS;
PARAMETER VALUE
----------------------------------------- ------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-YY
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET US7ASCII
NLS_SORT BINARY
NLS_NCHAR_CHARACTERSET US7ASCII Hence you can set, and use a default date format, in this case DD-MON-YY.However as a developer I use the TO_DATE function when wanting to set a date.eg vd_mydate := TO_DATE('25-07-2008','dd-mm-yyyy');Or the TO_CHAR function when displaying a date in the way I want to see it.eg. SELECT TO_CHAR(my_date_col,'"The "ddspth" of "Month, yyyy') FROM dual;
SOURCE: 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.
68 views
Usually answered in minutes!
×