If DateSold is null then use Date() in workday function

[fin2012]

I have two query expressions which works separately:
Days1:

IIf(IsNull([DateSold]),Date()-[DateBuy],Workdays([DateBuy],[DateSold]))

Day4:

Workdays([DateBuy],Date())

but when combined it does not work - too many arguments:

Days5:

IIf((IsNull([DateSold]),Workdays([DateBuy],Date()),Workdays([DateBuy],[DateSold])))

what is the solution please?

[Rabbit]

You have an extra set of outside parentheses on your Days5 expression.

[NeoPa]

As Rabbit says, it should be :

Days5: IIf(IsNull([DateSold]),Workdays([DateBuy],Date()),Workdays([DateBuy],[DateSold]))

An alternative approach might be :

Days5: Workdays([DateBuy],Nz([DateSold],Date()))

[fin2012]

Thank you Rabbit for the solution.

[fin2012]

I like the Nz suggestion, much neater. Thanks for that NeoPa.

[NeoPa]

My pleasure Fin :-)