Passing DATETIME Parameters to a Stored Procedure in OPENQUERY?

[FarmerKenny]

I am not able to define the @DateFrom and @ DateTo parameters in this OPENQUERY  that I am using as my connection to SQL Server:

SELECT *
FROM OPENQUERY ([HostName],
    'EXEC databasename.dbo.stored_procedure_name
        @DateFrom = CONVERT(DATETIME, ''2024-04-25''),
        @DateTo = GETDATE(),
        @Client_Id = NULL,
        @ClientStatus = ''ACT'',
        @InsurancePlan = ''1'',
        @InsurancePlanStatus = ''ALL''');

I get this error: "Microsoft SQL: Statement(s) could not be prepared.
Incorrect syntax near the keyword 'CONVERT'."  

Can someone please suggest the correct syntax for the @DateFrom and @DateTo parms? 

[amitchandak · Accepted solution]

@FarmerKenny , Try like , if the database is SQL Server, Azure SQL or the one uses T-SQL

SELECT *
FROM OPENQUERY ([HostName],
    'EXEC databasename.dbo.stored_procedure_name
        @DateFrom = CONVERT(DATETIME2(6), ''2024-04-25''),
        @DateTo = CONVERT(DATETIME2(6),GETDATE() ),
        @Client_Id = NULL,
        @ClientStatus = ''ACT'',
        @InsurancePlan = ''1'',
        @InsurancePlanStatus = ''ALL''');