time zones can be within a state. Indiana and KY, for example, have two time zones depending on where you are in the state. I would not rely on a STATE to get the time value.
Thanks for your response.
What would you suggest the best way to do this?
Perhaps using the ZIP code?
Zip code might be more accurate, but you'd need to know the standards for each area. Some areas do not observe Daylight Savings Time, and I believe, that some, from time to time, have changed on dates other than the standards ones, so you'd need know the "rules" for each company location so you could apply them correctly.
If you have a way to "lookup" the time zone (Insert from URL, perhaps) based on ZIP code, yes, I'd think that might work.
We've run into a similar pattern before with cities and counties. (One city can span more than one county.) We have tables for cities and counties, where a city can be linked to more than one county (we use a multi-line key). When someone selects a city/state combo that could have one of multiple counties, we ask the user to pick.
Could you do the same with states and time zones? If they pick FL, for instance, it's definitely EST, but if they pick KY, ask them which time zone?
IMHO, the best source of info about which time zone they're in is the person who's talking to the customer at the time, and can ask the question.