| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Calculated Field in Pivot Table Based on Two Counted Fields | Excel Discussion (Misc queries) | |||
| #NUM! in Date field calculation | Excel Worksheet Functions | |||
| How do I add a date field in a spreadsheet? | Excel Worksheet Functions | |||
| Print Footer with Last Print Date field name | Excel Discussion (Misc queries) | |||
Hybrid Mode
