[BC30108] 'convert' is a type and cannot be used as an expression

[nachoju]

Hi everybody.
i am trying to run a report and it is showing some errors of datatime format.

xml with mistakes-->"fechadesde" and "Fechahasta" are filters that are declarated as string but they i want to convert as datetime.

<Query>
        <DataSourceName>PEPITO</DataSourceName>
        <CommandText>="USE " &amp; Parameters!bd.Value &amp; " EXEC SP_AYA_RS_CC '" &amp; Parameters!fechaDesde.Value &amp; "','" &amp; Parameters!fechaHasta.Value &amp; "','" &amp; Parameters!proveedorDesde.Value &amp; "','" &amp; Parameters!proveedorHasta.Value &amp; "','" &amp; Parameters!codFamDesde.Value &amp; "','" &amp; Parameters!codFamHasta.Value &amp; "'," &amp; Parameters!fecha.Value &amp; ",'" &amp; Parameters!empresa.Value &amp; "'"</CommandText>
        <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
      </Query>

to convert them i have changed from:

& Parameters!fechaDesde.Value & "','" & Parameters!fechaHasta.Value & "','"

to:

... & convert(datetime,Parameters!fechaDesde,103) & "','" & convert(datetime,Parameters!fechaHasta,103) & ...

but it is giving me this error: [BC30108] 'convert' is a type and cannot be used as an expression

Anyone can help me?

thank you!

[Rabbit]

Aren't you using ASP.Net? And from your convert function call, you're using SQL Server correct?

Convert is a SQL Server function, not an ASP.Net function. The convert call will need to be within the quotes and the variable without. But if I am correct in that you are using SQL Server, there's no need to convert to a date time, it can do that implicitly.

[nachoju]

@Rabbit
This xml file (rdl extension) give parameters to a stored procedure of SQL. I tried to change the variable type inside the procedure but it doesnt work so I decide to change it in the xml file, before it give parameteres to the stored procedure....
I am new with this... is possible you write down the sentence?

thks for all your help

[Rabbit]

The data type in the stored procedure is DATETIME correct? And you're using SQL Server? What I'm saying is that SQL Server will do the conversion implicitly, you don't need to explicitly convert it unless you're using some sort of weird date time format. In which case you should get a different error. In that case, you will need to convert it. And I explain what you need to do in that case in my previous post.

The convert call will need to be within the quotes and the variable without.