date parameter for sp with a convert and Crystal 7

[timscronin]

have 3rd party app which still uses Crystal 7 with a SQL 2000 db. If you create a sql stored proc and define one of the prompting variables as datetime Crystal wants a hh:mm:ss with the calendar control. If you send it over as a varchar(10) you won't get Calendar control. I want the calendar control but no hh:mm:ss. ANyone seen this before?

 

[synapsevampire]

SQL Server doesn't have a DATE data type, only DATETIME, so everyone using SQL Server has seen this.

Another stewpud MS design.

An alternative might be to use a View and create a Crystal date parameter.

-k