I need to filter one year and one month before date in excel sheet from current date. I tried so many ways, but it can,t work. If anyone knows how to do that, please share with me

Help Studio
, ,
18

@lokeshkumar.k
This Conditions allow only past 13 months data and current month data

DateTime.Now.AddMonths(-13)<=ExcelDate and DateTime.Now>ExcelDate

This Conditions allow only past 12 months data and current month data

DateTime.Now.AddMonths(-12)<=ExcelDate and DateTime.Now>ExcelDate