I am using Membership and note that all the dates set in the aspnet_Membership table are minus one hour.
My development platform is XP and my timezone is set to GMT + 0.00 with "automatically adjust clock for daylight saving changes" checked.
Currently we are in British Summer Time (joke!) which is GMT + 1 hour = BST.
If I set a DateTime field = NOW(), the DateTime field is set to BST.
When using the Login control, however, the DateTime set in any field, LastActivityDate, LastLockedDate or FailedPasswordAttemptWindowStart, is BST - 1 = GMT.
First question is, should I set dates to be in GMT all the time or BST when it applies?
If GMT all the time (which seems to be the preferred option?), how do I remove the daylight saving time when I set a DateTime field?
If BST when it applies, how do I add this to the dates set by the Login control?
Your help would be much appreciated (any codes snippets preferably in VB, please).
Thanking you in anticipation.
View Complete Post