I have a crystal report that is to show a date parameter (date/time). I want the date parameter to be compared to a gifteffective date(date/time) and produce an error message if it does not match. The issue here is I am running a report from outside of crystal that will pass the parameter value to the date parameter within crystal. Essentially I type in the date (ie 3/12/08) Then I want to compare the date parameter value to the existing gifteffective date which is a date/time data type in crystal.
Assuming the parameter outside of crystal is a text box:
1. Is it best to convert both the date parameter and gifteffective date to text
2. Is it best to convert both to a date (date) and not a date/time
3. Since I am runnig the report from outside of crystal, is there a way to type the date as a string, then have crystal convert it to a date format for comparison
IP Logged