Date calculation

[KGee]

I have a date in dd-mmm-yy format. I extracted the two digit year and need to increase or decrease by one year. How can I use the code below to return the two digit year?

If year1 = "09" Then
    year2 = year1 - 1
End If

I realize I can add a check to see if the first digit is a 0 and take the appropriate action or change the date format to a four digit year before calculating, but I'm wondering if there is simpler way to do it, like using the format function or similar.

Thanks - Kevin

 

[VoG]

If year 2 is a string try

year1 = "09"
If year1 = "09" Then
    year2 = Format(year1 - 1, "00")
End If

 

[KGee]

Thanks once again for your help VoG. I probably should have been able to figure that oout on my own. At least I was on the right track

Thanks again.