In my Sink I’m running a Pre SQL Script to delete data after a certain date but I’m having trouble using parameters in the script.

here is my date paremeter variable inside dataflow and below is my pipeline paremeter and sql script

DELETE FROM dbo.DAP_WD_Timecard_Analysis_Test WHERE Reported_Date > '{$date}'

This is the error i’m receiving below. I’ve tried using a Date type instead of String with the same result. This works when I hard code the date.