get data between two dates

[KNRaju105630]

Hi Community,

Below is the my table, I have to get data before 12/31/2022 (first I have to consider Date1 and  Date2 also have to consider when not exist Date1)

COUNT(ID) should be 4

COUNT({<Date1={"<=$(=DATE#('12/31/2022', 'MM/DD/YYYY'))"}>}ID) - this expression I'm getting 3 only 

How to compare both dates ?

ID	Date1	Date2
100	1/1/2023	1/1/2023
101	4/1/2023	4/1/2023
102	1/1/2023	1/1/2023
103	1/1/2023	7/1/2022
104	7/1/2022	4/27/2023
105	3/1/2021	3/1/2021
106	7/1/2020	7/1/2020
107	4/27/2023	4/22/2023

Thanks in Advance!

[maxgro]

maybe

COUNT({

<Date1={"<=$(=DATE#('31/12/2022', 'MM/DD/YYYY'))"}>

+

<Date2={"<=$(=DATE#('31/12/2022', 'MM/DD/YYYY'))"}>}

ID)

[KNRaju105630]

not giving any value, PFA,

[maxgro]