ExcelBanter - how do i TRUNC a date field using SQL Server ODBC ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i TRUNC a date field using SQL Server ODBC ? (https://www.excelbanter.com/excel-discussion-misc-queries/95450-how-do-i-trunc-date-field-using-sql-server-odbc.html)

Nick Newton

how do i TRUNC a date field using SQL Server ODBC ?

I am using SQL Server typpe ODBC conection in Excel and when I try to TRUNC a
date field i get an error that the function is not recognised. Is there an
equivalent function to TRUNC for SQL server, I have used it before with
oracle ODBC connection.

All times are GMT +1. The time now is 03:04 AM.