AnsweredAssumed Answered

HELP! converting Excel formulas into Filemaker calculations?

Question asked by lcarter on Feb 2, 2010
Latest reply on Feb 2, 2010 by philmodjunk

Title

HELP! converting Excel formulas into Filemaker calculations?

Post

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.

 

Thanks

Outcomes