Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
maybe
COUNT({
<Date1={"<=$(=DATE#('31/12/2022', 'MM/DD/YYYY'))"}>
+
<Date2={"<=$(=DATE#('31/12/2022', 'MM/DD/YYYY'))"}>}
ID)
not giving any value, PFA,