1 Reply Latest reply on Feb 2, 2010 1:40 PM by philmodjunk

    HELP! converting Excel formulas into Filemaker calculations?

    lcarter

      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