I am running a Database of Club members, and want to be able to track how long someone has been a member. I have a custom field "Initial_Membership_Date" I have a second custom field "Years_of_Membership" "Years_of_Membership" is a calculated Number field with the following formula: YEAR(TODAY() )- YEAR(Initial_Membership_Date__c) Even in cases where the "Initial_Membership_Date" is properly populated with a date, the field remains blank. Anyone have any thoughts?

I am running a Database of Club members, and want to be able to track how long someone has been a member. I have a custom field "Initial_Membership_Date" I have a second custom field "Years_of_Membership" "Years_of_Membership" is a calculated Number field with the following formula: YEAR(TODAY() )- YEAR(Initial_Membership_Date__c) Even in cases where the "Initial_Membership_Date" is properly populated with a date, the field remains blank. Anyone have any thoughts?