If there is a need to use a Date as a parameter on a Crystal subreport, it is important to keep in mind the difference between a date and a datetime parameter. A Date parameter is just a date (01/01/14) but a DateTime parameter must have a time on it (01/01/14 01:00:00). If the value being passed to the date parameter is a date from the system, such as EV200_EVT_START_DATE, then it must be converted to a date before passing it as a parameter. Most date columns are actually datetime values as distinct Date and Time column types were only more recently added to Microsoft SQL.
To convert to a Date, create a formula that uses Date({COLUMN}) to convert it to just a date. Then the formula can be passed to the subreport.
Comments
0 comments
Please sign in to leave a comment.