Re: topic at http://sjc.ironspeed.com/post/TimeZones-..-again-5442932
While this is an old topic, it was of interest to me because I want to use GMT for all my audit entry times. Currently (ISD 9.2.0) there is no GMT function for the Formulas, so here's my solution:
If you edit the BaseFormulaUtils.vb file (of your project, not the IS installation), you can use that new function in database formulas. To add a GMT function, add this code following the existing Now() function:
''' Returns today's date with current time in Coordinated Universal Time
''' <returns>Today's date with current time in Coordinated Universal Time.</returns>
Public Shared Function UtcNow() As DateTime
Then, in the Batch Meister Wizard, make sure these formulas are present:
ChangedOn = UtcNow()
CreatedOn = UtcNow()
That accomplished, any table in your database with a datetime field named ChangedOn or CreatedOn will automatically have the GMT entered into those fields whenever an insert or update occurs.
Hope this is helpful. I'd like to hear from anyone who has a better way.