Hi,
  I have two DateTime fields in the DB StartDateTime and EndDateTime.The format in which it is stored is follows "2/9/2010 4:02:40 PM".Now i want to find out the difference between the Date Time fields and display in HH:MM:SS format. i tried to use Date Diff formula as follows
DateDiff("s",CDateTime(Date({ProcessInfo.EndTime})),CDateTime(Date({ProcessInfo.StartTime})));
                             but it is returning 0.0 when both the fileds are on the same day but only the time is different. how solve this problem?

Thanks for the reply,
           got the solution for it, it was giving 0.0 always because i am using only the date value and not the time value in the date diff fuction.This is how i fixed it
DateDiff("s",CDateTime(Date({ProcessInfo.StartTime}),Time({ProcessInfo.StartTime})),CDateTime(Date({ProcessInfo.EndTime}),Time({ProcessInfo.EndTime})));
                              now i pass time value along with date, so that i get the exact seconds between two date Time fields