Posted by: exinger
I'm using "Select DateTime_Start, DateTime_End,
@TIMEVALUE(DateTime_End-DateTime_Start)"
but @timevalue returns a wrong number of days (always 30) for the same day
of the date!
A sample:
DateTime_Start=20.02.2005 08:00:00 (european date-> dd.MM)
DateTime_End =20.02.2005 09:10:10
The difference should be 00 01:10:10 (the tablefield is formated "dd
hhhh:mm:ss")
but I get 30 01:10:10
Any suggestions?
Thanks
Maria Exinger