See PRB: DateTime Subtraction May Not Produce an Exact Integer mskb #258998.

>
>Maybe I am tried, need a vacation, or to take my meds, but in any case I am lost. The following code gives me 2 different calculation results for my DateTime Fields
>
>The field cFromDateTime is data-entered as 15/08/2007 08:45:00 AM and cToDateTime is data-entered as 15/08/2007 09:15:00 AM. This gives me the following results:
>4a 1800
>4b 29 60
>5 59 1
>
>But when field cFromDateTime is data-entered as 15/08/2007 12:00:00 AM and cToDateTime is data-entered as 15/08/2007 12:30:00 AM. This gives me the following correct results:
>4a 1800
>4b 30 0
>5 0 0
>
>

>*** total seconds
>lnTotalSecs = EVALUATE(THIS.cToDateTimeField) - EVALUATE(THIS.cFromDateTimeField)
>
>*** div. by one minute
>WAIT WINDOW "4a" + STR(lntotalsecs)
>lnMins      = INT(lnTotalSecs / (1 * 60))
>lnTotalSecs = lnTotalSecs - (lnMins * 60)
>WAIT WINDOW "4b" + STR(lnmins) + STR(lntotalsecs)
>
>*** div. by one second
>lnSecs      = INT(lnTotalSecs / (1))
>lnTotalSecs = lnTotalSecs - (lnSecs)
>WAIT WINDOW "5" + STR(lnsecs) + STR(lntotalsecs)
>

>
>What should it be rest, vacation or meds :) ?