Format data in a Parameter
Posted on 2007-12-06
Dates in the database are stored as numbers, such that a date of 12/07/2007 is stored as 20071207 and in crystal shows as 20,071,207. We would like to use a date field in a parameter but want to display as mm/dd/yyyy. We can manipulate the field with a formula field to desired format, but this field is not an allowed option in the value drop down on parameter settings. In essence, can you apply a function to a parameterized value? If not, what is the work around to this?