Parameter Datatype issue while passing it to SQL query

[rajashreemane]

Hello All,

I am unble to change Date parameter format while passing to SQL Query.

MY database Date format is "YYYY-MM-DD" and Parameter passes with Format "DD-MM-YYYY"

Resulting into below error

DataSource.Error: Microsoft SQL: Error converting data type nvarchar to datetime.

Can someone please help to resolve this issue

Thanks

[dax · Accepted solution]

Hi rajahreemane, 

You could try to change parameter data type to Text like below

 Or you could define parameter type in M code like below

let GetData=(para1 as text)=>
let
    Source = Sql.Database("servername", "newsql", [Query="select dayt, name  from timeformat  where  dayt= '"&para1&"' "])
in
    Source

    in GetData

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.