Hello All,

I have a difficulty formating my year variable in my data set.
The data set is a huge table composed of different excel files the data of which was collected from different students. The problem is that the year-variable contains different formats of the date e.g. in the first 690 rows the year is listed as 1/1/2007 from the 691st row it is only 2007. I need to show only the year and ignore the day and month.
The solution should be a simply while loop but I couldn't figure it out.

Thank you in Advance
Dimitar