1 Reply Latest reply on Mar 18, 2011 3:08 PM by philmodjunk

    Get(currentdate)

    helidude

      Summary

      Get(currentdate)

      Product

      FileMaker Pro

      Version

      11.3

      Operating system version

      Mac osx

      Description of the issue

      Get(currentdate) will only produce the correct date on the creation of a file. It will not provide todays date after creation. All of the formulas that reference this fucnction return incorrect dates.

      Steps to reproduce the problem

      have included screen grab -- the date_test on left is using the get(currentdate) function and the button on the right works correctly using the insert command for the button.

      Exact text of any error message(s) that appear

      no error message

      Workaround

      have tried to include in startup script with no luck

        • 1. Re: Get(currentdate)
          philmodjunk

          Like many get functions, this calcluation field must be an unstored calculation field in order to update correctly.

          1. Define a field of type calculation.
          2. Select Date as its return type
          3. Enter Get ( CurrentDate )
          4. Click the storage options button
          5. Select the "do not store calculation results..." option