| View previous topic :: View next topic |
| Author |
Message |
| kennedyma
| | Joined: 15 Oct 2007 | | Posts: 5 | |
|
 Posted: Mon Oct 15, 2007 11:05 am Post subject: 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 |
|
| Back to top |
|
 |
| kennedyma
| | Joined: 15 Oct 2007 | | Posts: 5 | |
|
| Posted: Mon Oct 15, 2007 11:27 am Post subject: |
|
|
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. |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in
Log in to check your private messages
