Date----year

[Zifeou]

I have got a date/time field named [DateBorrowed]

Now i wanna create a field call [Year] which show the year in [DateBorrowed]

How am i supposed to do this??

Thanks

 

[Nouba]

There is a function called Year which will give you the desired result. In an empty column in the qbe editor write
YearBorrowed: Year([DateBorrowed])

 

[Zifeou]

Thanks