Filter BEFORE fixed date (Power Query)

[adambc]

I have built a Power Query that filters BEFORE today last year as follows, populating the 12 with a GetValue query that picks up a value from a named cell in the Workbook ,,,

[LastCompletedDate] < Date.AddMonths(DateTime.LocalNow(),-12)

... but it now appears that the REAL requirement (!) is a fixed date cut off, not a fixed period ie ...

[LastCompletedDate] < {a fixed date that has been entered into a named cell in the Workbook}

... how would I code that?

I know what the syntax looks like if I use a Power Query date filter ie (for 1/4/2020) ...

[LastCompletedDate] < #datetime(2020, 4, 1, 0, 0, 0)

... but how would I turn eg 1/4/2020 entered into the named cell in the Workbook into the correct syntax ie (2020, 4, 1, 0, 0, 0)?

Thanks ...

 

[Alex Blakenburg]

There are quite a few steps to this but they are pretty clear if you read this (its a link):-
Power Query Parameters – How to use Named Cells as Flexible Inputs (by Access Analytic)
It uses your exact same terminology of CutOffDate.

There is a warning about privacy setting but the article was written in May 2018 so I tried it without changing the settings and it seemed to work fine.
I tucked it away some time ago when I was looking at being able to use a cell to determine the data source for the query which is also covered in that same article.

 

[adambc]

Perfect, thanks ...