Hello,
I have a table like this:
id date
11 2002/05/01
11 2002/07/01
22 2002/06/01
22 2002/07/01
22 2002/09/01
i would like to produce a report (a table...)
with this info:
id date date date difference
11 2002/05/01 2002/07/01 diff1
22 2002/06/01 2002/07/01 2002/09/01 diff2 diff3
diff1= nombre of days betrween 2002/05/01 and 2002/07/01
diff2= nombre of days betrween 2002/06/01 and 2002/07/01
diff3= nombre of days betrween 2002/07/01 and 2002/09/01
i think i need to create a temporary table, do you have any idea ?
thanks
I have a table like this:
id date
11 2002/05/01
11 2002/07/01
22 2002/06/01
22 2002/07/01
22 2002/09/01
i would like to produce a report (a table...)
with this info:
id date date date difference
11 2002/05/01 2002/07/01 diff1
22 2002/06/01 2002/07/01 2002/09/01 diff2 diff3
diff1= nombre of days betrween 2002/05/01 and 2002/07/01
diff2= nombre of days betrween 2002/06/01 and 2002/07/01
diff3= nombre of days betrween 2002/07/01 and 2002/09/01
i think i need to create a temporary table, do you have any idea ?
thanks