Hi All
I need get the difference in minutes between 2 dates.
If I hard code in the dates datediff ({hh}, 2014-05-01, 2014-05-02) it works fine.
If I use the columns from our Cogos Package
datediff ({hh}, [Patient Summary].[Admitting Date].[Admitting Date], [Patient Summary].[Discharge Date].[Discharge Date])
I get the following error. UDA-SQL-0219 The function "datediff" is being used for loacal processing but is not availbale as a built-in function, or at least on e of the parameters is not supported.
We are using SQL Server 2005 database.
Thanks
Craig