Hi, I have this data. Now I have to fetch the data for current year Rate, Previous Year Rate by emp code. Like for Emp Code - 74561 - Financial Year 2021 - 2022 Rate is 10920012. For 2020 - 2021 We don't have rate So rate will be same 2021 - 2022 Rate is 10920012.
But For 2019 - 2020 We have rate, So we have to check max From and ToDate and Rate is 10500000.
Please find the attached xls for data.
Thanks