Subtracting two date columns of two different records of same table
186543Aug 19 2005 — edited Aug 19 2005I have a table called wotask which contains multiple tasks for a work orders. I would like to be able to subtract the start date of one task from the finish date of another task and store the difference in a variable.
I would really appreciate if some body can extend help in this regard.
Thanks
Zahoor