Date subtracting

[ghiasibrahim]

Hi guys
How to subtract date in the current row from date in the previous one and show the result in column. I managed to do it in Multiplying, in the attached example.
I appreciate your Ideas and help.

[pbaldy]

I can't look at the sample right now, but you can get the previous value and use the DateDiff() function.

http://allenbrowne.com/subquery-01.html#AnotherRecord

[ghiasibrahim]

thank you pbaldy for your reply, but I couldn't use the information. it will be very nice from you if you could put the query into my sample when you have time.
appreciate you help.