4 Replies Latest reply on Feb 16, 2010 8:14 AM by comment_1

    Field which copy a year from a date field

    millebjoerk

      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