Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
curious date results
Try looking at the regional settings on your machine.
Excel will use these as the default date format. It's likely that oracle is returning them in mm/dd/yyyy format. If there is a mismatch you will only notice it with dates like 14/7/03 and not 7/7/03 as 7 is both a valid date & month. -- Regards, Bill Lunney www.billlunney.com "andyL" wrote in message ... I have a curious problem, I have made an Excel macro command (VB6) with which I run a select query in an Oracle Database, the query returns a line from dates in a Excel Sheet, the date format of the sheet is dd/mm/yyyy hh:mm:ss. The problem is that certain prices are with error format (mm/dd/yyyy hh:mm:ss) For example if the results from the beginning of this month it would supposed to be like: 01/07/2003,02/07/2003...10/07/2003..14/07/2003,15/07/2003 they are appearred to me: 07/01/2003,07/02/2003....07/10/2003...14/072003,15/07/2003 It's anyone out there that knows why this happen? I hope you understand me cause English is not my native language. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
curious date results
My regionals settings are dd/mm/yyyy
the date format in excel is dd/mm/yyyy hh/mm/ss the sql query in the SQL Plus got not any problem. The problem is the same is there any way to stabilise the date from my code??? -----Original Message----- Try looking at the regional settings on your machine. Excel will use these as the default date format. It's likely that oracle is returning them in mm/dd/yyyy format. If there is a mismatch you will only notice it with dates like 14/7/03 and not 7/7/03 as 7 is both a valid date & month. -- Regards, Bill Lunney www.billlunney.com "andyL" wrote in message ... I have a curious problem, I have made an Excel macro command (VB6) with which I run a select query in an Oracle Database, the query returns a line from dates in a Excel Sheet, the date format of the sheet is dd/mm/yyyy hh:mm:ss. The problem is that certain prices are with error format (mm/dd/yyyy hh:mm:ss) For example if the results from the beginning of this month it would supposed to be like: 01/07/2003,02/07/2003...10/07/2003..14/07/2003,15/07/2003 they are appearred to me: 07/01/2003,07/02/2003....07/10/2003...14/072003,15/07/2003 It's anyone out there that knows why this happen? I hope you understand me cause English is not my native language. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Curious interaction W/Win Exp. | Excel Discussion (Misc queries) | |||
Curious math | Excel Discussion (Misc queries) | |||
Just curious | Excel Discussion (Misc queries) | |||
Just curious | Excel Discussion (Misc queries) | |||
Curious about SUMPRODUCT | Excel Worksheet Functions |