>>Thinking about this a little more, it's not a trivial problem. You'd need to test if VFP does any compensation already at the time changes.
>
>It doesn't. Let's assume the time of your message and a week before that. That should be 7*24+1=169 hours, because we've had the time moved (actually on my machine it was moved manually - because of the bug Windows once had, I've dropped the automatics):
>
x=DATETIME(2007,11,8,14,14,12)
>x8=DATETIME(2007,11, 1, 13,45,56)
>?x8-x
>?x-x8
>SET DECIMALS TO 13
>?(x-x8)/(24*3600)
>
>
>The only adjustment I suspect VFP makes is usage of seconds() over midnight - it was changed at some point to continue counting and not reset to zero. Not sure when does it actually reset - there's zero mention of any change in the Help.
Did you check around the date where the time USED to change i.e. the last Sunday in October?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up