Date Format change

[mv8167]

Thx again Inborntester
With:
DateRequested="02/27/2012"

#1, Using:

Code:

DateRequested = month(DateRequested) & "-" & day(DateRequested) & "-" & year(DateRequested)
I get:
"2-28-2012"

#2, Using:
stryear = right(DateRequested, 4)

Code:

strmonth = left(DateRequested, 2)
strday = left(right(DateRequested, 7), 2)
DateRequested = strmonth & "-" & strday & "-" & stryear

I get:
"02-28-2012"

Can #1 also show as "02-28-2012"?