Help with Cross Time Zone calculations

[Rico]

Hello,

I have a situation where I have an SQL Server AND a remote MS Access
application sitting in one timezone, while the people dialing in (via remote
desktop) to do the work are in another time zone. The timezone where the
the server and application reside observes daylight savings time, while the
timezone where the user resides does not observe daylight savings time. If
daylight savings time was observed in both places, then I could simply
adjust the current time by two hours to make them equal, but that won't work
since one zone doesn't observe daylight savings.

Is there any way I can see if daylight savings is in effect to determine
whether I should adjust 1 or two hours? or if anyone has a better way of
handling this please let me know.

Thanks!
Rick

[Isaiah]

Post by Rico
Hello,
I have a situation where I have an SQL Server AND a remote MS Access
application sitting in one timezone, while the people dialing in (via
remote desktop) to do the work are in another time zone. The timezone
where the the server and application reside observes daylight savings
time, while the timezone where the user resides does not observe daylight
savings time. If daylight savings time was observed in both places, then
I could simply adjust the current time by two hours to make them equal,
but that won't work since one zone doesn't observe daylight savings.
Is there any way I can see if daylight savings is in effect to determine
whether I should adjust 1 or two hours? or if anyone has a better way of
handling this please let me know.
Thanks!
Rick

[Douglas J. Steele]

See whether http://www.mvps.org/access/api/api0024.htm at "The Access Web"
helps.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

Post by Rico
Hello,
I have a situation where I have an SQL Server AND a remote MS Access
application sitting in one timezone, while the people dialing in (via
remote desktop) to do the work are in another time zone. The timezone
where the the server and application reside observes daylight savings
time, while the timezone where the user resides does not observe daylight
savings time. If daylight savings time was observed in both places, then
I could simply adjust the current time by two hours to make them equal,
but that won't work since one zone doesn't observe daylight savings.
Is there any way I can see if daylight savings is in effect to determine
whether I should adjust 1 or two hours? or if anyone has a better way of
handling this please let me know.
Thanks!
Rick

[Rico]

Thanks Doug,

At first glance, it looks like that will do the job, but will have to have
some time to look at it more closely. If that doesn't work, then I'll try
your solution Ken.

Thanks!~

Rick

Post by Douglas J. Steele
See whether http://www.mvps.org/access/api/api0024.htm at "The Access Web"
helps.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

Post by Rico
Hello,
I have a situation where I have an SQL Server AND a remote MS Access
application sitting in one timezone, while the people dialing in (via
remote desktop) to do the work are in another time zone. The timezone
where the the server and application reside observes daylight savings
time, while the timezone where the user resides does not observe daylight
savings time. If daylight savings time was observed in both places, then
I could simply adjust the current time by two hours to make them equal,
but that won't work since one zone doesn't observe daylight savings.
Is there any way I can see if daylight savings is in effect to determine
whether I should adjust 1 or two hours? or if anyone has a better way of
handling this please let me know.
Thanks!
Rick