getting the current UTC/GMT

[Eden Morris]

Im connecting with a mySQL database and it uses UTC/GMT time for the modification timestamp field. Is there a timestamp function that will take daylight saving into account and generate a UTC/GMT timestamp?

[comment]

Do you mean you want to generate the current UTC in Filemaker?

[Eden Morris]

yes please

Do you mean you want to generate the current UTC in Filemaker?

[comment]

Don't know of a really good solution for this, I'm afraid. Filemaker looks strictly at your computer's local time, so additional information needs to be supplied from outside.

If you [a] are sure user computer's time is correct, and know the user's timezone, and [c] know the user's DST rules, you can calculate the UTC from those three.

Another option is to get the UTC from the OS via an OS-level script (requires user computer's time and location to be set up correctly) - or use a web-viewer to get the UTC from an outside service (requires an active Internet connection).

[Vaughan]

Filemaker looks strictly at your computer's local time...

The Get( CurrentHostTimestamp ) function returns the timestamp from the computer hosting the file.

[comment]

The Get( CurrentHostTimestamp ) function returns the timestamp from the computer hosting the file.

Yes, of course - if the file is hosted. But then Filemaker looks strictly at the host computer's local time, etc.

[Vaughan]

Yes indeed... it does not help the problem.