Kentman
Active Member
- Joined
- Apr 26, 2010
- Messages
- 260
I'm having users input dates through 3 drop-downs into string variables: SNTDay, SNTMonth & SNTYear - and there is a string variable that constructs the date thus: SNTDate = SNTDay & "/" & SNTMonth & "/" & SNTYear
However, when it puts the result into a sheet it is coming out as 08/03/2010 not 03/08/2010 - the formats have been set correctly in the sheet and my time zone is correct in control panel even when I output the SNTDate to a MsgBox it is correct but not when it goes into the sheet.
I'm stumped!
However, when it puts the result into a sheet it is coming out as 08/03/2010 not 03/08/2010 - the formats have been set correctly in the sheet and my time zone is correct in control panel even when I output the SNTDate to a MsgBox it is correct but not when it goes into the sheet.
I'm stumped!