AnsweredAssumed Answered

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

Question asked by penhaifai on Jan 19, 2010
Latest reply on Jan 20, 2010 by 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

 

 

 

 



Outcomes