Hi, I'm trying to execute a named query to get some data for a home page widget.

It worked fine until i added some date functions (getdate(), datediff, dateadd)

Those are transformed by the slx provider in slxgetdate, slxdatediff, slxdateadd. I suppose that the purpose is to provide a generic function which will be transformed in something SQL Server or Oracle understands. However, when I run the profiler, I can see that both client and executed SQL are using the slxxxx functions. SQL Server does not know slxgetdate and the other functions, so the query fails.

I really need these in my query, does anyone know why the executed SQL does not use the regular SQL Server date functions?

Thank you in advance for your suggestions.