>CREATE TABLE Test (Timespan I) >APPEND BLANK >REPLACE timespan WITH {09/27/97 08:30am} - {09/27/97 08:00am} >BROWSE > >Hmmm, the value stored in the field is 1799. It seems the value returned >by the subtraction of two time fields is not an integer value and it gets >truncated when storing in a integer field. The DateTime field is stored as two integers - one for the Julian date number, the other for the number of milliseconds. So, the seconds are stored with three decimals, no more, no less. You've probably hit a rounding issue here, which may depend on your Set Decimals. Set your Timespan field not to an integer, but to currency instead, and see what happens. I expect you'll have even more fun :)