4 Replies Latest reply on Nov 7, 2013 9:27 AM by DavidJondreau

    Date, Time and Auto Enter options...

    PeterWindle

      Could someone please confirm where the date and time come from when using auto enter creation date/time options on date/time fields?

      Does the date and time come from the user's computer, or the host?

      Is it better to use auto enter calculation using get(currentdate)/get(currenttime) ??

        • 1. Re: Date, Time and Auto Enter options...
          filemaker_mmfg

          Auo enter creation date and time are user's computer date and time.

          For a good result in multiuser application it would be better to use the host timestamp, by a script with Get(CurrentHostTimeStamp)

          • 2. Re: Date, Time and Auto Enter options...
            flybynight

            filemaker_mmfg - Is a script necessary, or can you simply use an auto-enter calc with Get(CurrentHostTimeStamp)?

             

            But in general, yes auto-enter date/time/timestamp are on the client machine, so whenever possible I use the "Host" version of time, just to keep things consistent.

             

            I don't have any experience with systems large enough to have users in multiple time zones, so I'm not sure what issues you would run into with that.

             

            Laters,

            -Shawn

            • 3. Re: Date, Time and Auto Enter options...
              filemaker_mmfg

              The advantage of the script is that it can be triggered as you need, i.e. when you create the record or when you commit it, so the consistency can be driven based on what you need. This is specially useful when many people create many records in the same time.

              • 4. Re: Date, Time and Auto Enter options...
                DavidJondreau

                I use a custom function in an auto-enter calc. That custom function can do a few things, but I start off with Get ( CurrentHostTimestamp). Then if it's the host is in a different timezone than all the users, I can adjust the function to match local time. If it's a "multi-user in different time zone situation" then I can adjust the custom function to meet the business needs.

                 

                For modification timestamps, I use a calc that that references the modification account name field with the same custom function.