I have a Stored Procedure in SQL 2005 that returns a date in this format 11/07/2008.
SQL was returning 2008-11-07 00:00:00.000 but I converted the field to the above format.
In the report when I'm prompted for the date I can enter a date and a time.
At this point the report returns no records.
I'm suspicious it's a date\Time issue.
Do I have to create a start and end date to give CR a range?
Is there a way to pass just the date and have CR return everything for that date?
I'm not sure what I need to be passing to CR.
Any help would be apprecitated...