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.