time - Greenwich Mean Time Susanne 12/30/2008 8:27:18 PM Has anyone ever incorporated GMT (Greenwich Mean Time) into Access? Didn't know if it is possible, since most of the time / date values are based on the computers clock.

Re: time - Greenwich Mean Time "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> 12/31/2008 1:36:54 AM To store a time as GMT rather than your local time, you just need to know your local timezone and use DateAdd() to add the number of hours difference. Here's some API calls to figure out the user's time settings: http://vbnet.mvps.org/code/locale/timezonedisplay.htm http://vbnet.mvps.org/code/network/netremotetod.htm http://vbnet.mvps.org/code/locale/timezonebiaslookup.htm -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Susanne" <Susanne[ at ]discussions.microsoft.com> wrote in message news:E2FB0974-8F0A-451F-8AAE-C769ACDE36F0[ at ]microsoft.com... [Quoted Text] > Has anyone ever incorporated GMT (Greenwich Mean Time) into Access? > Didn't > know if it is possible, since most of the time / date values are based on > the > computers clock.