Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to write the below set analysis condition.
If count=1 then it has to display the data between two years.
Example
emp_id count Date
1 0 08/07/2022
2 1 08/09/2021
3 1 08/07/2020
1 1 08/07/2021
1 1 08/07/2020
The resultant output should be
if count=1 and year between 2021 and 2022
2 1 08/09/2021
1 1 08/07/2021
if count=1 and year between 2020 and 2021 then
2 1 08/09/2021
3 1 08/07/2020
1 1 08/07/2021
1 1 08/07/2020
can someone help in writing the set analysis code this example