Server Based Time Stamp

[hob]

Does anyone know of a way to get current time from the Server rather than the client machine? We have a time tracking system setup that requires a get current time function. The problem is that we need to make sure that all the client machines have their time set accurately.

Would love to be able to get the current time off the FMServer machine or some other centralized computer.

[Fitch]

Get(CurrentHostTimestamp)

[hob]

Ouch!!!

That was too easy!

Thank you!!

[Steven H. Blackwell]

Of course you can't use it automatically as the auto enter modification value. But see the tip on John Mark Osborne's web site for how to have the Host Time Stamp be the automatically generated one.

I premiered this at a recent FMDiSC meeting.

Steven

[LaRetta]

Hi Steven!

I looked for what you mentioned on JMO's site and couldn't find it. However, there are many techniques which work... Check Auto-Enter by calculation and uncheck Do Not Replace Existing value. You need a modification timestamp field anyway, then any calculation such as:

Let ( trigger = regular Auto-Enter TimeStamp field ; Get ( CurrentHostTimeStamp ) )

or

If ( regular Auto-Enter Timestamp field ; Get ( CurrentHostTimeStamp ) ; Get ( CurrentHostTimeStamp ) )

Each time the standard auto-enter modification timestamp changes (meaning any field data changes within that table) then calc will fire as well. If you have a way without using an regular auto-enter modifcation timestamp to trigger it, I'd like to know! Of course you can also put all fields within the Let() as:

Let ( trigger = StartDate&EndDate&User&Amount ... ; Get ( CurrentHostTimeStamp ) )

I am sure there are even more ways. Is the way you're suggesting different still? I'd love to see it. Can you tell me where to look on his site?

LaRetta :wink2:

[Steven H. Blackwell]

Search for Host Modification Stamp.

Steven