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?

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

yes please

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

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).

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

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

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.

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