difference - Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
See your earlier thread. I've responded there.

Rick B said:
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.
Click to expand...
 
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.
Click to expand...
 
Back
Top