Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Date-time substraction
thanx Venkat -- will give this a try. I believe I tried something like that and got the same number for all entries..... Maybe that says something for my typing skills also.- plt737
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Date-time substraction
I have a sql statement like the following:<br>SELECT AVG(86400*(Disp_DT-Entry_DT))/60 AVG_TIME<br><br>How can I make a Crystal formula like the one above?? Disp_DT is Dispatch Time and Entry_DT is Entry Time. My Oracle time field is like the following: 2000,01,31,15,01,27 - <br>yyyy,mm,dd,hh,mm,ss.- plt737
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 4 Other topics
