Hi All
I have Data as below, When I select any two dates, I need how many ids has the target date got changed, I was trying with the above approach and unable to achieve.( May be i'm not able to do it).
Can you please suggest the way to do this. I need another Date field as CLOSED DATE for my date range selection.
Say if I select DATE_UNIT = '3/Apr/2018' and CLOSED DATE = '2/Jul/2018' I need count as '1' as the target_date got changed from 31/Jul/2018 to 31/Aug/2018.
Similarly for DATE_UNIT = '1/May/2018' and CLOSED DATE = '1/Jun/2018' I need count as '1' as the target_date got changed from 31/Jul/2018 to 31/Aug/2018.
Same for 1/May/2018 to 2/Jul/2018
For 3/Apr/2018 to 1/May/2018 the count of ID should be '0' as the target date didn't got changed.
| ID | DATE_UNIT | Target_Date |
| I-00043959 | 3/Apr/2018 | 31/Jul/2018 |
| I-00043959 | 1/May/2018 | 31/Jul/2018 |
| I-00043959 | 1/Jun/2018 | 31/Aug/2018 |
| I-00043959 | 2/Jul/2018 | 31/Aug/2018 |
