Sage 100

v5.1 Crystal reports - How do you default a date or date-time parameter to today's date?

If you click on the calendar, doesn't it default to today's date?

@ThereseLogeais Good point. Apparently the client doesn't like that possible one extra click.

Set your parameter to the End Date Only, then set a manual formula for selecting records which uses the current date through that End Date. Something like this: {IM_ItemTransactionHistory.TransactionDate} >= currentdate and {IM_ItemTransactionHistory.TransactionDate} <= {?EndDate}

I use a ""hasvalue"" formula: if hasvalue ({?ReportDate}) then {?ReportDate} else currentdate

(The parameter needs to be set to optional too I believe).

Is hasvalue a Crystal reserved word?

Yes. From the CR help files: Basic and Crystal syntax. Arguments Parameter field Returns Boolean Value Action Evaluates the parameter value passed as the argument and returns TRUE if it has a value, FALSE if it has no value.

Thanks. I will give it a try.