Forum Discussion
Solved
Date Between filter not working
I used the between filter to filter on RcptPostingDate (date DataType), but the outcome was not what I expected I filtered the dates to be between 12/01/2021 and 12/31/2021, but I got data ...
I used another apprach to filter because none of the suggested solutions worked for me. (Error wass so random).
My Approach: instead of fiiltering date, I filtered month.
Hi abinashphuel
It looks like you shifted position of the step applied and I suspect the Modified format of the column is not quite in place, that's why Power Query can't recognise the date column as Date format.
Re check the steps applied
I applied that filter after I applied Filter Rows and Filter Rows1.