I have a worksheet that lists the times for numerous events in PT (not specified if DST or standard time). I have had a request to insert another column with GMT equivalents for each event. I can run the code where I specify the offset from PT but haven't figured out how to set it up automatically to check whether we are in standard or daylight savings time to correct the offset. I have created a table with the start and end dates for 2011 to 2015 but am not sure how to have it check the specified date to see if it falls in or out of that range or if there is a better way...it is not usually the system date but instead a date chosen by the user from a calendar control (called "DSSEDate" declared as date elsewhere in the code).

Any thoughts?


Thanks,
Judy