Year val string

If I wanted to create a piece of code that was able to detect the year as being '3' (2003) would this code be sufficient

yearval = Left(2, Year(dateval))

Or would in need something else? I have tried using the above with different variables and it does not seem to work.

Thanks

Yearval=Year(Date)... what's wrong with this?

For the name of the file I am looking for I only need the '3' of the 2003 thats why I was looking at using a string

VB Code:

Private Sub Form_Load()
    MsgBox CInt(Right$(CStr(Year(Date)), 2))
End Sub

Quote:

---

Originally posted by krtxmrtz
Yearval=Year(Date)

---

...followed by
Yearval=Right(Yearval,1)

Thanks for your help