>>>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?
Yes - just set DATETIME(2007,10,8,14,14,12), and it still gives a round number of days; if I use DATETIME(2007,10,8,15,14,12) (i.e. one hour later), I get 30.9583 days instead of 31.0000. So no, it does not adjust anything on my machine.
Did anyone else test this?