DATE instead of DATETIME parameter

[nlaliberte]

Good Morning
I'm using Crystal XI and an ODBC connection to a SQL Server.

I'm running a report off of a stored procedure that calls on a datetime parameter (@report_date). I would like to prompt the user for just a DATE, and leave out the timestamp, however once I connect to the procedure in Crystal I do not have the option to change the parameter type.

Is there a way to run a report of a procedure that calls a DATETIME parameter, but only prompt the user for a date?

 

[AndersonCJA]

I would try to create a formula field in which you convert the stored procedure datetime field to a date field, then use the formula field (date) as the parameter. I don't have my crystal reports available to me right now, so I'm not able to double check my idea.