I am using Crystal Reports to report on a stored procedure in SQL 2000. For the purposes of my query I just need the date and not the time. Actually, the time portion is what is screwing me up. If I execute the following in the Query Analyzer it works fine:

EXEC NLF_Test '9/11/02'

However, the programs designer has stored the datetime as 9/11/02 00:00:00.

How can I change the input parameter to just the date?

I have delcared it as follows @dPayDate datetime. How do I extract the pertinent data. For some reason I am having trouble with concatenation.

Thanks