Default Parameter Field Date and Time
I'm thinking there's an easy fix for the problem below I just can't figure it out. I have a report that I need to pass a Date/Time field to but it's not working right. The field I'm trying to pass the info in to is a Date/Time field but I only need to pass the date part of the field not the time. The issue I'm having is that when I select the date I want Crystal Corral defaults to the current time thus it's not a match. I need the time part to say 00.00.00.0000. Not the current time. Any suggestions?? Below is and example of the data: TICKET_DATE 2007-10-13-00.00.00.0000 2007-10-13-00.00.00.0000 2007-10-13-00.00.00.0000 2007-10-12-00.00.00.0000 2007-10-12-00.00.00.0000 2007-10-12-00.00.00.0000 2007-10-12-00.00.00.0000 2007-10-12-00.00.00.0000

Never mind, a little more tweaking and I figured it out. I just made a static parameter field for the date only. That seems to work just fine.