Calculation with message for invalid date needed.

[schooltechie]

Hi! I have been asked by a school nurse to come up with a calculation that will warn if an immunization date is less than one year from the date of birth. I have played with several formulas, and I can't quite seem to get the exact number of days I need. I want to have it calculate so that if the number is 365 days or more, nothing need be done. But, if the number is less than 365 days, I want a text message to say "INVALID". Can anyone help me come up with this formula? Thanks.

Becky

[BobWeaver]

Create the following calculated "Message" field:

Message = Case(ImmunizationDate-DateOfBirth<365,"INVALID","")

[ April 30, 2001: Message edited by: BobWeaver ]