Date Ranges

[trafficstudent]

Below is an equation that i want to preform so that if my users dont select a start or end date it will default and show 01/01/2004 else if my users want to use a start date and end date he can still do so.

Can anyone help me with my formula?


if {?Date Range} = currentdate then
start date= "01/01/2004"
else
{WorkOrder}={?Date Range}

 

[Madawc]

You need a formula field, maybe StartFormula with something like

If @StartParamDate = currentdate
then Date(2004, 1, 1)
else @StartParamDate

Put this in selection, something like

{WorkOrder} in [@StartFormula to @EndParamDate]

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10