HELP! converting Excel formulas into Filemaker calculations?
I am a brand new user to Filemkaer Pro. I am using FMP 9; MS XP Pro OS.
Our department has gone to using FMP for our database that was formerly kept in Excel. I have formulas set up in Excel to calculate when things are due example: =EDATE(F1257,12) that adds one year to the date in the cell identified (F1257). How can I make a calculation that will do the same thing in FMP? I need FMP to be able to take the date that I enter in field A and add one year to it and populate field B with that data?
I have never worked with databases before and I know nothing about scripting, though I am registering for some SQL classes through continuing education.