1 Reply Latest reply on Apr 15, 2012 3:30 AM by Sorbsbuster

    Calculating Dates



      Calculating Dates


      I'm using FMP 10 and would like to know how to calculate dates.  For instance, I need to take a contract date and add 56 years to it and have it show as a date (2/5/1956).  When I go into calculations and put contract date + 56, it ads 56 days and it shows up as numbers, not dates. Can you help me on this?

      Also, in my portal I have the persons name, association, etc. on the first line and the company they are with on the second line.  When I try to search for the persons name, it won't let me search the second line for the company they're with.  Is there someway I can search from more than one line in the portal?

      Thanks for your help.


        • 1. Re: NoFields

          You could use the calculation:

          Date ( Month (ContractDate ) ; Day (ContractDate ) ; ( Year (ContractDate ) + 56 ) )

          and set it to return type 'Date'.


          You can't search for more than one record in a portal.  But you can search on any number of fields in the portal, even if the one record in the portal is over two lines.  You may have set the Company field to be not enterable in Find Mode.