VB Forum / General / October 2007

Dear All,

I have a VB 6.0 program using DateTimePicker Control(DTP).
The purpose of DTP is for User to search record within the range of starting
date and ending date.
User need the date as "dd/MM/yyyy" format in the DateTimePicker Control.

My PC is running on Window XP.
Regional and Language setting is English(US) with short date format is in
"dd/MM/yyyy" format.
With the below code, DTP display the date correctly on my PC.

The program also installed on another PC with Window 2000 Pro.
Regional and Language setting is the "dd/MM/yyyy".
Previously it can generate the expected result until 01/10/2007(1st Oct 2007).
Since that day, 1st Oct 2007 display as 10/01/2007 in DTP.

Example:
dtFromDate.Value = 10/01/2007
dtToDate.Value = 10/02/2007
When dtFromDate is dropdown, it show current selection is 10th January 2007.
When dtToDate is dropdown, it show current selection is 10th February 2007.

The program also save date as 10th January 2007 instead of 1st October 2007.

Private Sub Form_Load()

   dtFromDate.Value = Format(Date, "dd/MM/yyyy")
   dtToDate.Value = Format(Date + 1, "dd/MM/yyyy")
   
   dtFromTime.Format = dtpTime
   dtFromTime.Value = "08:00:00 AM"
   dtToTime.Format = dtpTime
   dtToTime.Value = "08:00:00 AM"

End Sub    

I get back the program and test out on my PC, it work correctly.
Why the same exe can work at my PC but not at User PC?
Why it can work until 30th September but got problem after that?
Could anyone shed some light?

Thank you.