SQL statement syntax error when using DATEADD()

[t-zhanqi]

I want to get the Monday of the CreatedDTim.

But i encountered an error while trying to connect.

[v-easonf-msft]

Hi , @t-zhanqi 

What kind of your database ?

PowerBi has a variety of database connectors, if possible, it is recommended to use them directly rather than ODBC connectors.

I try to  test your sql satement under the environment  of sql server, there is nothing wrong can be find.

Can you run the statement normally in your database?

Best Regards,
Community Support Team _ Eason

[t-zhanqi · Accepted solution]

HI, @v-easonf-msft  

Thank you for your help. Your reply is of great help to me in solving this problem. I have solved this problem by using TIMESTAMPADD(). The reason I can't use DATEADD() is that my data source is ODBC instead of SQL SERVER. 

[v-easonf-msft]

Hi,  @t-zhanqi 

It's pleasant that you can share your sloution to us, people who meet a similar problem will be very happy with it.

Please accept your reply as solution, so that other community members will easily find the solution when they get the same issue.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@t-zhanqi , refer these for sql server date add

https://www.w3schools.com/sql/func_sqlserver_dateadd.asp

https://docs.microsoft.com/en-us/sql/t-sql/functions/dateadd-transact-sql?view=sql-server-ver15

I doubt it has anything to do with power BI. Incase this SQL is working on SSMS and not working here, then it needs to be checked.

[t-zhanqi]

Thank you for your help. I have solved this problem by using TIMESTAMPADD(). The reason I can't use DATEADD() is that my data source is ODBC instead of SQL SERVER.