datediff()

[craigalaniz]

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