AnsweredAssumed Answered

Field which copy a year from a date field

Question asked by millebjoerk on Feb 16, 2010
Latest reply on Feb 16, 2010 by comment_1

Title

Field which copy a year from a date field

Post

Hi

 

I have a date field A, which contain date of the format dd-mm-yyyy.

I would like to have another field B which only contains the year from field A. I've tried several calculations, but it won't work.

I also need result of the calculation in field B to be in text, because it is further going to be related to value list, where the years a written in text format.

 

Hope somebody can help me, and please tell me if you don't understand my problem.

 

Regards, Mille

Outcomes