I would like the yearsCalculation field in the card data table to calculate the closest whole number of years from the anniversaryDate.
For example the 1/12/2011 would calculate as 4 in the yearsCalculation filed. Or the 1/01/2012 would calculate also 4 in the yearsCalculation filed.
I would like this field to be an auto calculation. When we import data it should calculate for us.
Please let me know if you have any questions.
8 freelancers are bidding on average $24 for this job
Hello. Thank you for the invitation. My bid is $30 plus the fee the site charges. The job is done in the file you attached. If you contact me through here I can attach the file for you to test it.
Hello Sir, I have more than 4 years experience in Filemaker Database development. I can easily resolve this issue.I am waiting for your further response. Thanks & Regards Avick Mukherjee
4 years 8 months exp in filemaker versions 11,12 and 13 both fm go and fm pro. Questions Explain the DateAnnivesary field we will design a calc as auto enter