4 Replies Latest reply on Jan 20, 2010 3:41 PM by penhaifai

    two Dates deference and the outcome should b a specific text sentence!!

    penhaifai

      Title

      two Dates deference and the outcome should b a specific text sentence!!

      Post

      I have two Date type fields. One for the record creation date and the other; let's say; for DOB; date of birth; and I have this criteria to come up with;

       

      0-6 Months
      7-12 Months
      1-2 years
      3-4 years
      5-6 years
      7-8 years
      9+  years

       

      How can I calculated the date deference and then pick the relevant criteria? It should b shown in a field.

       

       

      thank you in advance