1 Reply Latest reply on Oct 19, 2010 7:14 AM by TSGal

    Why I can not get the right Date with Date formula

    wisdomz

      Title

      Why I can not get the right Date with Date formula

      Post

      Dear Sir?miss

      i import Excel file into FM, the date format is "12/30/2010". but , I did not know how to get the right year to complete the conditional format.

      For examples:  year(PGI date) >2010,  what is right formula.

       

      regards

      Wisdom

       

        • 1. Re: Why I can not get the right Date with Date formula
          TSGal

          Wisdom Zhang:

          Thank you for your post.

          Year (PGI date) > 2010

          is the correct formula.  What is the calculation you are trying to display?

          Also, check to make sure "PGI date" is a Date field.  Otherwise, the formula will not work.  Return to Manage -> Database... and check to make sure PGI date is a Date field.  If not, change it.

          TSGal
          FileMaker, Inc.