How to pass a dynamic parameter to Power Query SQL code

[BLB]

I would like to define a dynamic parameter which I can use in the SQL query to filter a specific date.

I created this query which is generating the correct number I want to use dynamically every day, but cannot use it in the SQL statement.

Any suggestions welcome please.

Thanks

[DataInsights]

@BLB,

Try concatenating the parameter in the SQL statement:

...SYSDATE + '" & OffsetForLastTuesday & "' and SKULOC...

[BLB]

Thanks for the suggestion but now I am getting this error. 

[DataInsights]

@BLB,

Try adding the single quotes in my example. Also, the plus sign after SYSDATE in your original query is missing.

[BLB]

I tried all combinations, with ', ", &, on their own and in all combinations an none of them works for me. 

[DataInsights]

@BLB,

Try wrapping the parameter in Text.From. I think the parameter needs to be text in order to concatenate it with text.