How To Exclude Rows Using Date Filter With Between Operator in Power Query

[Anonymous]

Hello Team,

This might be a simple for you experts, but I am stuck.

I have created a power query filter on  a date column.

=Table.SelectRows(#"PrevStep", each [Clearing Date] >= #date(2020, 2, 1) and [Clearing Date] <= #date(2020, 12, 31))

My requirement is not to keep these rows. Can anyone help me with this ?

Thank You in advance. 

[Anonymous]

Thank You @CNENFRNL.

[CNENFRNL · Accepted solution]

One step away,

= Table.SelectRows(#"PrevStep", each not ( [Clearing Date] >= #date(2020, 2, 1) and [Clearing Date] <= #date(2020, 12, 31)))

or

=Table.SelectRows(#"PrevStep", each [Clearing Date] < #date(2020, 2, 1) or [Clearing Date] > #date(2020, 12, 31))