You can translate the question and the replies:

Facing error while executing TRUNC(date,'IW') in sql server database via sql server JDBC adapter

Hi team, I have gone through the documentation. It mentioned that trunc(date,'IW') will not work for sql server jdbc adapter. But can you suggest some alternatives that could helped to achieve the above mechanism?
user
30-08-2023 03:20:40 -0400
code

1 Answer

Hi, Executing [TRUNC function](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/datetime_functions/datetime_functions#trunc) against a view from a SQL Server data source is supported by the Denodo Platform. Please note that the function is not delegated to the SQL Server data source but is performed on the Virtual DataPort server. If you are facing any error when executing the function, you can further troubleshoot the issue by checking the [Execution Trace](https://community.denodo.com/docs/html/browse/8.0/vdp/administration/creating_derived_views/querying_views/execution_trace_of_a_statement) of the query to find more information on the error. Additionally, you can also check the logs inside the **vdp.log** file which is located at <DENODO_HOME>\logs\vdp directory. Hope this helps!
Denodo Team
31-08-2023 20:01:36 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here