General information
Category:
Coding, syntax & commands
Title:
Help with Datetime calculation (Has to do with DST)
I have a table with a seperate record for each day of the year. On this record I have 4 times (ie. 4:00AM 6:20AM 3:35PM 8:30PM). I run calculations on this table based upon adjustments to each time (ie 30 minutes, 45 minutes....)The program also has to adjust for changes from one day to the next and vice versa if the adjustment is a negative. All works fine except for Daylight Savings Time. Is there a way to tell the program or calculation to adjust for DST or will I have to hard code the actual dates for DST in the calculations.
BTW, the base starting table before adjustments get calculated by some other means and does not account for DST.(I already thought of that)
TIA,
Jamie
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only