spliting one piece of informaiton into multiple variables (VBA)

[smakatura]

I want to ask a user for a date via an input box.

date = InputBox("enter date of report")

the format of the date will remain consistant mm-dd-yy

and then separate out the parts into 3 variables. so
month = mm
day = dd
year = yy

what vba code would assign the month, day and year from the date input?

 

[smakatura]

I like the code above specifically

format (ddate, mmddyy)

if my file has the date as mm-dd-yy (02-01-11), what would be the proper syntax for the format function

 

[AlphaFrog]

Format(dDate, "mm-dd-yy")

 

[smakatura]

thanks that is perfect. you guys rock

 

[tweedle]

Isn't that where we started?

the format of the date will remain consistant mm-dd-yy

= Format(dDate, "mm-dd-yy")
<!-- / message --><!-- sig -->