Date issue

Kentman

Active Member
Joined
Apr 26, 2010
Messages
257
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!
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,343
the Type of the variable should be Date (not string)
but iven if this cuase not problem - did you try with a date more than 12
it looks like you construct it correct once then vba ( or excel reoders it again)
 
Last edited:

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,948
Messages
5,508,307
Members
408,676
Latest member
Anmol N

This Week's Hot Topics

Top