Difference between dates in groups

Asked Mar 31 '16 at 12:13

Active Apr 14 '20 at 19:26

Viewed 62 times

I want to calculate difference between dates. There are characters, for example, '2014-01-01' in days and in groups in R. I did something similar in DB2:

DAYS(DATE(my_date)) - DAYS((LAG(my_date) OVER (PARTITION BY my_group ORDER BY blabla ))

my_group  my_date      diff
1         '2014-01-01'  NA
1         '2014-01-02'  1
1         '2014-01-05'  3
2         '2014-01-01'  NA
2         '2014-01-02'  1
2         '2014-01-06'  4
3         '2014-01-01'  NA
3         '2014-01-02'  1
3         '2014-01-10'  8
3         '2014-01-11'  1

edited Apr 14 '20 at 19:26

Mario Boss

1,784
3
20
43

asked Mar 31 '16 at 12:13

Agnieszka

2

Try to give us an example :), it's better to inderstand – Mostafa90 Mar 31 '16 at 12:15

Difference between dates in groups

0 Answers0