Marshall Barton wrote:
Date/Time values are internally represented as Doubles with
the fractional part being the part of a day. It appears
[quoted text clipped - 18 lines]
arithmetic in the time value. That's the "bug" I guess... That is why i'm
going crazy...
I tried every way I can think of to reproduce (A2003) it and
could not get that effect. I don't know of anything that I
can add to what I said earlier.
maybe you can use the Immediate window to triple check the
value in the form text box. See if you get the same ouput
from these two lines:
?CDbl(Forms!yourform.thetextbox)
and
?CDbl(#13:00:00#)
Thanks again for the reply
i am using Access 2007
i tried this an the result is on both 0.666666666666666666667
maybe there's a problem with rounding numbers....
But...
Now this is really hard for me to understand.
i was trying to fix the time comfusion by assing General date types in the
program and i fell onto this problem
i get the values i present here in the debug mode.
starttime = "29/05/2008 11:30:00 am"
endtime = "29/05/2008 1:00:00 pm"
in the code there is a line like this
if endtime = starttime then msgbox("Wrong Parameters")
the funny thing is that i see the message box...
Now this i cannot explain.
Please help!
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201006/1