when i try to convert Date to Year i get error msg

[Paulyeo11]

Hi All

Can some one advise me :-

[Anonymous]

@Paulyeo11  Create A New Column and then use below Formula To create year .

Year = Year(Date) 

You will able to get the year from date .

Give me Kudos for correct Solution .

[Paulyeo11]

Hi Sir

Edit :- I just try to manually type and the Date Appear and i click on Date , and it work fine now. Thank you.

I follow your step , still get error :-

[amitchandak · Accepted solution]

@Paulyeo11 , You need to create a new column for this.

Check in the table tools. Or click a column. You will get that option.

refer to my video :https://www.youtube.com/watch?v=cs1ZQU3acWE