Hi Team,
I have a below situation
1) Find the difference between two dates and calculate the days.
2) Create bins based on the below criteria.
Please let me know how to go about it.
| Id | Date 1 | Date 2 |
| 1 | 12/13/2002 | 12/30/2021 |
| 2 | 1/15/2003 | 12/20/2002 |
| 3 | 4/8/2003 | 12/31/2003 |
| 2 | 7/2/2003 | 12/31/2020 |
| 4 | 8/6/2003 | 9/30/2003 |
| 4 | 8/6/2003 | 9/30/2004 |
| 4 | 8/6/2003 | 1/30/2004 |
| 4 | 8/6/2003 | 2/27/2004 |
| 4 | 8/6/2003 | 2/27/2004 |
| 4 | 8/6/2003 | 11/30/2003 |
| 4 | 8/6/2003 | 10/31/2003 |
| 5 | 8/6/2003 | 1/30/2004 |
| 5 | 8/6/2003 | 11/30/2003 |
| 8/6/2003 | 10/31/2003 |
Solved! Go to Solution.
