Linq query in excel


#1

Hi, I have to apply a query in excel so that i can apply a date filter which will show upcoming month, what logic I should use.

Problem statement - suppose I have year 2018,2017,2016 and so on and in 2018 we have months like jan, feb,march,april and may

If current month is march so I have to apply a filter so that it will show results only for april and may data.

Thanks!


#2

read excel then convert the date column to DateTime Format then you can where select query where date is >System.DateTime.Today.Month and date < System.DateTime.Today.AddMonths(2)


#4

Hi @Divyashreem - Can you help me to apply query where

date is >System.DateTime.Today.Month and date < System.DateTime.Today.AddMonths(2)


#5

Give me your Column name and sample data


#6

I have attached the sample sheet, and I have to apply filter on ‘Due on column’ on the last day of current month.

step 1- first I have to remove upcoming month in 2018 i.e, nov and dec and delete those rows
step 2- then to apply filter on last day of current monthsample.xlsx (2.5 MB)