
1. Re: how do i calculate the number of months between two date fields?
mrvodka Jun 22, 2010 1:07 PM (in response to paulbur02)What a month? 28, 29, 30, 31 days? The term is very relative and therefore, I usually stick to number of days.

3. Re: how do i calculate the number of months between two date fields?
paulbur02 Jun 22, 2010 1:15 PM (in response to paulbur02)number of days would be just as helpful if you could guide me through that

4. Re: how do i calculate the number of months between two date fields?
comment_1 Jun 22, 2010 1:23 PM (in response to paulbur02)For number of days, just subtract one field from another (result is Number).

5. Re: how do i calculate the number of months between two date fields?
paulbur02 Jun 22, 2010 1:45 PM (in response to paulbur02)thanks so much! and how can i put in the calulation to skip blank fields?

6. Re: how do i calculate the number of months between two date fields?
mrvodka Jun 22, 2010 1:50 PM (in response to paulbur02)Case ( not IsEmpty ( Date1 ) and not IsEmpty ( Date2 ); Date1  Date2 )

7. Re: how do i calculate the number of months between two date fields?
paulbur02 Jun 23, 2010 9:29 AM (in response to paulbur02)thanks for the reply! I input this field into my database and it works great, but, there are some fields that, for some reason, do not calulate this value, even though there is a date in BOTH fields (i've tried erasing the date and reinputting them but to no avail). any idea what this could be?? i even deleted the field and recreatd it but nothing
Case (not IsEmpty (shimAUA1DATE) and not IsEmpty (PrPSAD); shimAUA1DATE  PrPSAD)

8. Re: how do i calculate the number of months between two date fields?
mrvodka Jun 23, 2010 9:56 AM (in response to paulbur02)Are both date fields indeed date fields and the calculation field result of a number?