2 Replies Latest reply on Dec 9, 2010 12:02 PM by PemitaPaaga

    Is this a calculation?

    PemitaPaaga

      Title

      Is this a calculation?

      Post

      I am new to FileMaker Pro and I am building a Ticket System from scratch.  I want the completion date field to show current date when the status field value = closed.

        • 1. Re: Is this a calculation?
          philmodjunk

          You appear to have accidentally posted this question to the FileMaker GO forum instead of the FileMaker Pro forum. Wink

          If you define the field as a date field and use the auto-enter field option to specify this calculation:

          If ( Status = "closed" ; Get ( CurrentDate ) ; self )

          Clear the do not replace existing values option. Now, changing the value of the status field to "closed" will automatically enter today's date. If it is any other value in Status, the value you enter into this date field is what will be displayed.

          • 2. Re: Is this a calculation?
            PemitaPaaga

            Thanks!