Date Format change

[inborntester]

Right function first argument should be string type.

Can you try like.

Code:

stryear = Right("02/27/2012", 4)

Don't use year as variable, its a keyword.

moreover you can try the simply way by using month,day,year functions.

Code:

DateRequested="02/27/2012"
DateRequested = month(DateRequested) & "-" & day(DateRequested) & "-" & year(DateRequested)
msgbox(DateRequested)