Number Of Days Between Two Dates In Same Column

[#1]

I have to find the number of days between the dates for the same cu_id and add the number as a new column. The new table should look like this.

Cu_id |Tr_id |Date| Days_between
1234 |1 |12/3/2006 |0
1234 |2 |12/18/2006 |15
1234 |3 |1/5/2007 |18
1234 |4 |1/9/2007 |4

Thanks!

[#2]

Hi,

try Date - Before(Date) for your new column.

Rainer

[#3]

Tks Rainer Filoda but im a newbie, it doesnt work , i have differents Cu_Id
Regards

[#4 · Accepted solution]

Hi Shariel,

see the attached example (sorry for the typo: use ABOVE and not BEFORE).

Be shure that your dat format is correct.

Good luck!

Rainer

[#5]

it works perfectly

Thank you very much!

[#6]

Thank for your help, but I have one more doubt, if I do not have the field Tr_Id could I generate it?

Regards