i need the year only from the date format to display the year in a text box
so using the following code ,can any body give a specific solution to it
coz am getting the 'yyyy' only instead of a year like 2007

Dim getyear, newyear As String
getyear = Format(txtdate. Text, "yyyy")
newyear = getyear & "-" & getyear + 1