Subject: Server in GMT zone - how do I display all times locally?
OK, this is kinda “weird” most people want to see what time it is in their time zone… I’d be a little confused looking at a document after manking a change at 9am PST seeing it say it was updated at Noon EST.
You Said:
I’d like it if a person in New York creates a document, that all times on the form display in EST, even if I access the document from my client located in MST.
As it is now, timestamps in fields modified by agents show a GMT time, @modified fields show the MST time for me, and time @now fields used in showing document edit history show the EST zone… And NONE of them will show the actual zone.
Is the document creator’s time zone to be consider “the master” time zone to be display?
If so, I would then capture the person’s timezone information. (Computed when compose).
I don’t think you can modify @modified, but you can have a display field that changes what it shows.
As for your edit history, is this a TEXT field (vs a datetime) and therefore each time it’s updated it captures the persons date/time format? (so if I changed it and my format is yyyy-mm-dd you’d see that in the history).
I don’t know of any “show all date/times values using timezone in field X” so once you’ve captured the creator’s timezone, I would believe for all your fields where you show a date/time you’d need to convert what ever time it was set to the want to display the value timezone.
As for adding the TimeZone “field” definately a good idea. However, you need to be careful as I’ve found what Lotus Notes / Windows uses may not match what people are familiar with. EST - can be Eastern North Ameria or Eastern Australia.
Might play with this more tonight. I love this timezone stuff.