Passing Date as a parameter from package fails in string conversion

 
hellos,

i have a sql query for a report which works fine with current date but I want to instead ask the user for a date instead 
DECLARE @start DATE = CONVERT(date, GETDATE());
--
 Using User Input I want to ask the user for a date and pass the same in ETL report , I did a set variable for #dd# to '2025-09-17' 
I modified the script to 

 DECLARE @start_string VARCHAR(10) = '#dd#';      
DECLARE @start DATE = CONVERT(DATE, @start_string,23);

But I keep getting Conversion failed when converting date and/or time from character string

When I do TRY_CONVERT I simply get a blank report  

Can't see anything wrong with it
You might have spaces at the end/beginning or some invisible characters.
I would use trim to remove it

Or perhaps '#dd#' is never replaced
or it is replaced with '2025-09-17' 

eg:
 
DECLARE @start_string VARCHAR(10) = ''2025-09-17'';      
select  @start_string

DECLARE @start_string VARCHAR(10) = '#dd#';      
select  @start_string

wel #dd# absolultey has the value , since i tried the same with show message

I introduced a trim, but still conversion error

DECLARE @start_string VARCHAR(10) = trim('#dd#');      
DECLARE @start DATE = CONVERT(DATE, @start_string,23);


Any other way to troubleshoot this"

Please create a minimalistic package and attach it here 

i did try a 

SQL to text package and 

when I tried
DECLARE @start_string VARCHAR(10) = '2025-09-17';

SELECT 
    @start_string                        AS OriginalString,
    CAST(@start_string AS DATE)          AS CastedDate,
    CONVERT(DATE, @start_string)         AS ConvertedDate,
    TRY_CONVERT(DATE, @start_string)     AS TryConvertedDate;

My output was 
"OriginalString","CastedDate","ConvertedDate","TryConvertedDate" "2025-09-17","2025-09-17 00:00:00.000","2025-09-17 00:00:00.000","2025-09-17 00:00:00.000"

When I tried
DECLARE @start_string VARCHAR(10) = '2025-09-17';

SELECT 
    @start_string AS OriginalString,
    FORMAT(CAST(@start_string AS DATE), 'yyyy-MM-dd') AS CastedDate,
    FORMAT(CONVERT(DATE, @start_string), 'yyyy-MM-dd') AS ConvertedDate,
    FORMAT(TRY_CONVERT(DATE, @start_string), 'yyyy-MM-dd') AS TryConvertedDate;

Output was fine without timestamp

BUT THE MOMENT i tried passing  #dd# I start getting errors


Not able to read the data: SQLExecDirect(FHSMT,PChar ('DECLARE @start_string VARCHAR(10) = '2025-09-31';
 '), SQL_NTS) Failed: 22007 [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Conversion failed when converting date and/or time from character string.