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.
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |