Parenthesis and comma status

[Rose]

Can anyone figure out where the parenthesis and comma's might be wrong below?

Nights: IIf(DateDiff("d", IIf(CheckInDate < [Start Date],
[Start Date], IIf(Nz(CheckOutDate, Date()) > [End Date],
[End Date], Nz(CheckOutDate, Date()))) = 0, 1),
DateDiff("d", IIf(CheckInDate < [Start Date], [Start Date],
IIf(Nz(CheckOutDate, Date()) > [End Date], [End Date],
Nz(CheckOutDate, Date()))

 

[Jeff Boyce]

Rose

When I end up with one of these, I start counting, adding 1 for each left
paren and subtracting for each right paren ... ditto for other brackets.

I do have a question about this phrase:
IIf(Nz(CheckOutDate, Date()) > [End Date],
[End Date], Nz(CheckOutDate, Date()))) = 0, 1)
which seems to have an extra "=0" in the "false" side of the IIF().

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Rose]

Thanks for your help and clever way to check the , and )
--
Rose

Rose

When I end up with one of these, I start counting, adding 1 for each left
paren and subtracting for each right paren ... ditto for other brackets.

I do have a question about this phrase:
IIf(Nz(CheckOutDate, Date()) > [End Date],
[End Date], Nz(CheckOutDate, Date()))) = 0, 1)
which seems to have an extra "=0" in the "false" side of the IIF().

Regards

Jeff Boyce
Microsoft Office/Access MVP

Can anyone figure out where the parenthesis and comma's might be wrong
below?

Nights: IIf(DateDiff("d", IIf(CheckInDate < [Start Date],
[Start Date], IIf(Nz(CheckOutDate, Date()) > [End Date],
[End Date], Nz(CheckOutDate, Date()))) = 0, 1),
DateDiff("d", IIf(CheckInDate < [Start Date], [Start Date],
IIf(Nz(CheckOutDate, Date()) > [End Date], [End Date],
Nz(CheckOutDate, Date()))