Date Parameter field in Crystal report 10 ....
Posted on 2006-03-23
I am using stored procedure with my crystal report.
->My Stored Procedure is like:
Table1.Date >= @FromDate
Table1.Date <= @ToDate + ' 11:59 PM'
->When i run this stored procedure in SQL ANALYZER it returns 2 records for the @FromDate = '3/22/2006' & @ToDate = '3/22/2006'.which is CORRECT.
->When i click on parameter button in report:
I enter following values for the parameter:
For @FromDate: 3/22/2006 12:00:00 AM
@ToDate: 3/22/2006 11:59:59 PM
Report shows me 3 records.In that there is one record of date '3/23/2006 3:20:24 PM' which shouldn't be there.
Date field's values appears in sql analyzer as follows when i run my stored procedure in SQL Analyzer:
In table it looks like:
3/22/2006 3:20:24 PM
3/22/2006 3:39:15 PM
3/23/2006 3:20:24 PM
How do i fix this problem ? Please let me know as soon as possible.