Forum Discussion
abinashphuel
Advocate I
Advocate IDate 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.
aj1973
Community Champion
Community ChampionHi 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
abinashphuelAdvocate I
Advocate II applied that filter after I applied Filter Rows and Filter Rows1.