Date Parameter 1

[Lhuffst]

Using Crystal XI. Can you have a date parameter that allows users to select a date or leave it null?

I need to print records that have a meeting date matching the parameter or if they leave it blank, print all records that do not have a meeting date.

I know I can do this with a string but I look the calendar pick and would prefer to have that option available for users.

Maybe there is a way to leave it as a string but add in a calendar control? Is anyone familiar with this?
Thanks
Lhuffst

 

[lbass]

You can add a default of 9/9/9999 and then use a record selection formula like this:

(
{?date} = date(9999,9,9) and
isnull({table.date})
) or
{table.date} = {?date}

You should also enter prompt text like this: To show records with no meeting date, please enter: 9999-09-09; otherwise, select a date.

-LB

 

[Lhuffst]

Great! Thanks

 

[Lhuffst]

LB. Just switched my parameter to the way you suggested and it works perfect. Thanks
Lhuffst