Crystal Reports 10 Date Parameter mm/dd/yy to datetime

[xanra]

I have SQLServer 2003 database that keeps track of transactions in datetime. To make it easier on the frontend user I want to pass date parameters in the format of mm/dd/yy instead of standard datetime format.


I'm trying to get a listing of all the transactions that occurred during a specific day but when I pass a parameter {transactions.transdate}={?paramTransdate} I get no results. How can I pass this any help will be greatly appreciated.

I'm running CR10 that comes with VS2005. This is an ASP.net 2.0 application.

 

[synapsevampire]

Surprised it didn't work, but you can hardcode it as:

(
{transactions.transdate}>={?paramTransdate}-1
and
{transactions.transdate}<={?paramTransdate}+1
)

-k