summer time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am developing an application in access to track working hours of equipment.
However in Europe, as in a lot of countries the clock advance and retard
during the summer and autumn respectively meaning you have one 23 hour and
one 25 hour day each year. Access does not appear to account for this.
Obviously over the year my figures will be correct, but for two months of the
year they are wrong! Can anone advise on how to handle this problem.
 
hi,

Most computers automatically account for this "daylight savings time"
adjustment. If so, then there should be no problem with records in Access
during this time switch. You may want to check to see that any ocmputers
used to enter the data are set up to automatically adjust for daylight
savings time.

Hope this helps,
geebee
 
Thanks for the input geebee, this was my first thought that perhaps I had not
set the daylight saving option in the regional settings, unfortunately
however I had. I tried in excell also and this still only reprts 24 hours in
the period between 12:00 on the 28th October and 12:00 on the 29th October.
 
Hi Dave,

If this matters, I feel the best approach is to store all times as UTC
(GMT) or at any rate without daylight saving. That way, the working hour
calculations are simple.

For data entry, let users enter their "clock" time, and then have your
code add or subtract the relevant number of hours (depending on whether
daylight saving is in force or not) before you store the value.

If you need to display past times of day, it's a matter of writing a
query that calculates whether daylight saving was in force and
adds/subtracts the appropriate number of hours.



On Tue, 31 Oct 2006 04:22:02 -0800, Dave Warden <Dave
 
Back
Top