Convert Time Zone

S

ServiceEnvoy

I am building a database to track ebay auctions and they are all
listed as PDT time. I have a field called "localtime". Is there a
way to set the "localtime" field to look at the "PDTTime" field and
automatically calculate the local time?
 
K

Klatuu

You need to identify the time zone for each location as an offset from GMT or
Zulu time. GMT would be 0 The next time zone to the east is GMT - 1.

Now, there are a couple of places in the world that don't adhere to that
basic concept. Newfoundland, for example is 1/2 hour off the standard time
zone. I think there are one or two more, but I don't know where they are.

I would google for it. I would bet someone already has done this.
 
Top