We are using the Add Command feature to use queries to provide data to our reports. The date parameters from the query are then set in Crystal to datatype DATE. When setting up the parameter in the Designer, todayu2019s date appears in the default dialog box. However, if we leave that date, it stays the same when the report is run. In other words, if I build the parameter on Monday and leave Mondayu2019s date in the default box, when I run the report on Wednesday, the default date displayed will still be Mondayu2019s date.
How can I get the date parameter to default to the current date? My user would like leave the parameter alone sometimes (in order to get the current date), and select different date values at other times.