date and time subtractions

[change]

hi have two fields 1)assigned date and time 2)closed date and time and im looking to find the difference between the 2 fields ie datedifference and time difference what ive done is convert the both times to 24hr and am now trying to subtract them

[QVeen72]

Hi,

So...? You are not getting proper results..?
Can you post your code here...?

Regards
Veena

[VBWheaties]

hi have two fields 1)assigned date and time 2)closed date and time and im looking to find the difference between the 2 fields ie datedifference and time difference what ive done is convert the both times to 24hr and am now trying to subtract them

Use the DateDiff function:
DateDiff(interv al,date1,date2[,firstdayofweek[,firstweekofyea r]])

More detail here:

http://www.w3schools.com/vbscript/func_datediff.asp