Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can anyone help to provide code for below scenario (refer Date Diff column).
Here I need the date difference of below below date with the above date.
Group | Date | Date Diff |
A | 1-Jul-17 | 10.00 |
A | 11-Jul-17 | 6.00 |
A | 17-Jul-17 | 2.00 |
A | 19-Jul-17 | 0.00 |
B | 1-Aug-17 | 3.00 |
B | 4-Aug-17 | 9.00 |
B | 13-Aug-17 | 10.00 |
B | 23-Aug-17 | 8.00 |
B | 31-Aug-17 | 0.00 |
C | 1-Jun-17 | 5.00 |
C | 6-Jun-17 | 10.00 |
C | 16-Jun-17 | 3.00 |
C | 19-Jun-17 | 0.00 |
Regards,
Tom
Hi Sunny,
Some changes in my logic, so I have created a new thread, can take a look on this.
below is the link
Regards,
Tom