Forum Discussion
Data Range between different dates
Hi, I am trying to create a column filter or some type of measurement that will help me calculate the dates between several dates. I have a historical table that takes a weekly snapshot each Mon...
Hi Anonymous ,
I am not clear about your logic, I think the count of 4/20/2020 should be 3
Sample Data Snapshot Dates Cont Dates between Range Week Start Rang and End CurrentWeek 4/27/2020 4/13/2020 1 4/13-5/17 4/27/2020 4/18/2020 1 4/27/2020 2/3/2020 0 4/27/2020 5/20/2020 0 4/27/2020 5/5/2020 1 Last Week 4/20/2020 4/6/2020 1 4/6-5/10 4/20/2020 4/18/2020 1 4/20/2020 5/25/2020 0 4/20/2020 4/27/2020 1 4/20/2020 4/1/2020 1 this should be 0? 2 Weeks Ago 4/13/2020 4/12/2020 1 3/30-5/3 4/13/2020 3/30/2020 1 4/13/2020 3/25/2020 0 4/13/2020 4/26/2020 1 4/13/2020 5/20/2020 0 You could refer to my sample for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I am not clear about your logic, I think the count of 4/20/2020 should be 3
| Sample Data | Snapshot | Dates | Cont Dates between Range | Week Start Rang and End | |
| CurrentWeek | 4/27/2020 | 4/13/2020 | 1 | 4/13-5/17 | |
| 4/27/2020 | 4/18/2020 | 1 | |||
| 4/27/2020 | 2/3/2020 | 0 | |||
| 4/27/2020 | 5/20/2020 | 0 | |||
| 4/27/2020 | 5/5/2020 | 1 | |||
| Last Week | 4/20/2020 | 4/6/2020 | 1 | 4/6-5/10 | |
| 4/20/2020 | 4/18/2020 | 1 | |||
| 4/20/2020 | 5/25/2020 | 0 | |||
| 4/20/2020 | 4/27/2020 | 1 | |||
| 4/20/2020 | 4/1/2020 | 1 this should be 0? | |||
| 2 Weeks Ago | 4/13/2020 | 4/12/2020 | 1 | 3/30-5/3 | |
| 4/13/2020 | 3/30/2020 | 1 | |||
| 4/13/2020 | 3/25/2020 | 0 | |||
| 4/13/2020 | 4/26/2020 | 1 | |||
| 4/13/2020 | 5/20/2020 | 0 |
You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Zoe, The solution you provided worked and the results was 3.
Thank You!