Using a cell value to filter records by date

[TheWennerWoman]

Hello,

I am new to PowerQuery but learning fast

I have created two parameters (connection only) for my period_from and period_to - these will be dates.

I have fetched data from SQL and filtered the date to only return one day - I was hoping to then go into the M code and substitute the value in there with one of mine (well that's how they show you to do it on YouTube).....but in the M code I see this:

= Table.SelectRows(Source, each ([posteddate] = #datetime(2021, 4, 7, 0, 0, 0)))

What do I need to do next?

Thank you in advance.

 

[TheWennerWoman]

Ok, I have made some progress.

= Table.SelectRows(#"Changed Type", each ([posteddate] = PFrom))

gets me one day's worth of data; what do I need to do to get a date range?

I thought

= Table.SelectRows(#"Changed Type", each ([posteddate] >= PFrom), ([posteddate] <= PTo))

but it errors with Expression Error - there is an unknown identifier?