1 Reply Latest reply on Apr 18, 2012 2:07 PM by philmodjunk

    How do I do the comparison of fields get updated?



      How do I do the comparison of fields get updated?


      Hello All:

      Some weeks ago I asked how I can populate a field with a value from a field in a related table at the time of the record creation. Thanks to another member's help this problem is resolved.

      This field is a date. It could be in the future or past. Let me call this Field 1

      I have another field that automatically records the current date (Field 2). And yet another field (Fieldl 3 that is suppose to calculate if the Field 1 is greater than Field 2, and display a tex based on this:


      (Field1 > Field2, "OK", "NOT OK")


      I am discovering that this field automatically comes up as "NOT OK" when a record created. The form has at this point only the Field 2, which is a time stamp, and no value for Field1.

      Entering a value yet into another field (Field_related), starts the lookup process and fills in the date into Field1. But the value does not change in Field 3!

      I checked "DO NOT STORE" under "Storage Options" but this does not solve the problem.

      Any suggestions?


        • 1. Re: How do I do the comparison of fields get updated?

          Sounds like you need to keep text from appearing in this field until Field 1 receives a date.

          Case ( Field1 > Field2 ; "OK" ;
                    Field1 ; "Not Ok )

          This will return "OK" if there is a date in field 1 and it is greater than the value of Field2. It will return "not OK" if there is a value in Field1 and it is not greater than Field2. If field1 is empty, no value is returned and the field will be empty.