how do i calculate the number of months between two date fields?
i'm trying to create another field that will calucate the number of months between 2 separate date fields. how can i go about doing this?
What a month? 28, 29, 30, 31 days? The term is very relative and therefore, I usually stick to number of days.
See if this helps:
number of days would be just as helpful if you could guide me through that
For number of days, just subtract one field from another (result is Number).
thanks so much! and how can i put in the calulation to skip blank fields?
Case ( not IsEmpty ( Date1 ) and not IsEmpty ( Date2 ); Date1 - Date2 )
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 re-inputting them but to no avail). any idea what this could be?? i even deleted the field and re-creatd it but nothing
Case (not IsEmpty (shimAUA1DATE) and not IsEmpty (PrPSAD); shimAUA1DATE - PrPSAD)
Are both date fields indeed date fields and the calculation field result of a number?
Retrieving data ...