Hi All
I'm in Oz so our dates are dd/mm/yy.
I've got an XP issue. The following piece of code works correctly in 2000
.Offset(CurrRow, 31).Value = Format(CurrAdjFinishDate, "dd-mm-yy h:mm")
and produces
13-11-03 0:03
However when run on an XP machine with XL XP it produces the following
11/13/2002 12:03:00 AM
It thinks the 13 is the month not the day even though the above code ensures the format of the date is correct. Iv'e checked the formatthrough a msgbox and it looks OK - it only when it is put in the cell that it goes haywire.
Changing the format of the cell itself has no effect on the contents. It thinks it text because you can't have a 13th month.
The system dates are correct and use English(Australian).
Any ideas????