Sorry the query was timing out - I have managed to get it working within SSMS by adding

 Declare @theDateDATETIME

Set @TheDate ='2019-03-04'

and then using this in my select statement

WHERE (scheme.efg.PAL_product LIKE 'R00%') AND scheme.pallet.PAL_date= @theDate

But I was wondering how I would call this in my Report builder dataset as a Parameter instead of setting a specific date as per the query?
Thanks