• Post Reply Bookmark Topic Watch Topic
  • New Topic

Timezones and daylight savings  RSS feed

Dan Howard
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yesterday (Sunday) I had to rush into the office to trouble shoot a problem at a client site. Whenever they tried to save a record they would get a message saying that the record was locked (by them) and you can't save.

I tracked it down to our locking logic. We get the date/time the user locks the record and store it in the database. Then send that value as a hidden on the page. When the page get's resubmitted we compare to make sure the timestamp wasn't changed. What I saw was that the Calendar converted from this string was an hour ahead.

On the clents web servers we turned off the Windows feature "Automatically adjust clock for daylight savings" and the client was able to work.

I'd like to fix this in code and here is my solution. Is this a valid approach?

Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!