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