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.