September 5, 2006 at 6:56 pm
Jeff,
Would not have been able to do this without your kick-start. This had been puzzling me for quite a while. Thank you for your original post.
We have separate databases for each of our locations, so I created table tblRefTimeZone in each of the databases with one record in it.
For an eastern time zone plant, the Offset integer column is set to -5 and the DST bit is set to 1. A plant in California would have an offset of -8 and DST of 1.
Ron
September 5, 2006 at 9:22 pm
Brilliant... I'm impressed. Thanks for the feedback.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply