difference - Dates

[Guest]

Hi
I have a query whith Col-A, Col-B and Col-C. How can I do a difference(dates
Col-B(2nd row) and Col-C(1st row), …B(3th) and C(2nd),…. etc ) in Col-D?

Col-A Col-B Col-C Col-D (difference)
Xpto 15-Mar-06 16-Mar-06 -
Abc 18-Mar-06 20-Mar-06 2 (diff 18-Mar and 16-Mar)
Dfd 23-Mar-06 25-Mar-06 3 (diff 23-Mar and 20-Mar)
….

thanks

 

[Rick B]

You already posted this and got a response. Why are you reposting it?

If the first response did not answer your question, then go post to that
thread and explain why it did not work.

 

[John Spencer]

See your earlier thread. I've responded there.

You already posted this and got a response. Why are you reposting it?

If the first response did not answer your question, then go post to that
thread and explain why it did not work.

 

[Guest]

because the example that I wrote 1st, wasn't very good.
sorry it was my fault

do you have any suggestion for my query?
thanks
--
Sérgio Aires
Lisboa
Portugal


"Rick B" escreveu:

You already posted this and got a response. Why are you reposting it?

If the first response did not answer your question, then go post to that
thread and explain why it did not work.