>thanx
>but its retuning something like this -63737 and i want a nicer format

As I sad, it's the number of seconds between two datetime values. Here's the sample code that would convert seconds into HHHH:MM:SS format

*FUCTION SecToTime
* Convert seconds to the Time string
PARAM nSeconds
LOCAL cHH, nTm, cMM, cSec, cTime, i
cHH = ALLT(STR(INT(nSeconds / 3600)))
nTm = nSeconds % 3600
cMM = PADL(INT(nTm / 60), 2, "0")
cSec = PADL(MOD(nTm, 60), 2, "0")
cTime = cHH + ":" + cMM + ":" + cSec
RETURN cTime