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.
Define Field B as a calculation:
Date( day(field A) ; Month(field A) ; Year (field A ) + 1 )
and field B will show a date exactly one year in the future from the date entered in field A.
You could also use: Field A + 365, but might will be off by one day if a leap year is involved.