Forum Discussion
Complex Dates compare
Hello Experts, Please help me with this date comparison. I have a dates table with Snapshots Column where we take Snapshots every other Saturday. Sometimes there may be only one snapshot per month....
The logic is that all snapshot from the LY und LLY in the same (selected) month should be shown?
Yes, That's correct.
All these are examples.
If they select CY date the patten is like below.
| CY | LY | LLY |
| 12/31/2022 | 12/04/2021 | 12/05/2020 |
| 12/03/2022 | 12/04/2021 | 12/05/2020 |
| 11/12/2022 | 11/13/2021 | 11/14/2020 |
| 10/29/2022 | 10/30/2021 | 10/31/2020 |
| 10/15/2022 | 10/30/2021 | 10/31/2020 |
| 10/01/2022 | 10/02/2021 | 10/03/2020 |
| 09/17/2022 | 09/18/2021 | |
| 09/03/2022 | 09/18/2021 | |
| 08/20/2022 | 08/28/2021 | |
| 07/30/2022 | 07/31/2021 | |
| 07/16/2022 | 07/31/2021 | |
| 07/02/2022 | 07/03/2021 | |
| 06/18/2022 | 06/19/2021 | |
| 05/28/2022 | 05/29/2021 | |
| 05/14/2022 | 05/01/2021 | |
| 04/30/2022 | 04/17/2021 | |
| 04/16/2022 | 04/17/2021 | |
| 04/02/2022 | 04/03/2021 | |
| 03/19/2022 | 03/20/2021 | |
| 02/26/2022 | 02/27/2021 |
Thank you.