Date and time average

[NetworkGuy101]

I have 4 fields in a db. startdate, starttime, enddate, endtime. I want to be able to pull average time from startdate and starttime to enddate and endtime

Im not sure the best way to do this. I could do a loop or something but I was hoping one of you gents may have some experience. Help is appreciated.

Thanks

 

[webmigit]

I think you can learn a lot from this thread: thread232-805252

Having the datetimes in two fields each may present a problem.. but I think you can work with it.

If you can't or don't get a good answer.. I can think of a good code-side solution or two.. but like you said... that's just looping.

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.