IIF Statement

[mmazenge]

Please help me with syntax of this nested IIf Statement. I am trying to
track Internal Requisitions Status and report on it at any given time
as the requisition goes through various stages, i.e. raised, approved,
ordered and finally delivered, and can also be cancelled. The values of
these status are derived from a date and my syntax is as follows:

=IIf(IsDate([Fo_Date])=Yes, "Delivered", iif(IsDate([T_Date])=Yes,
"Ordered', iif(IsDate([S_Date])=Yes, "Approved","Waiting Approval")))

Thanks in advance

Regards

Memory.

 

[Bob Miller]

Take out the =Yes after each IsDate()

Please help me with syntax of this nested IIf Statement. I am trying to
track Internal Requisitions Status and report on it at any given time
as the requisition goes through various stages, i.e. raised, approved,
ordered and finally delivered, and can also be cancelled. The value
of
these status are derived from a date and my syntax is as follows:

=IIf(IsDate([Fo_Date])=Yes, "Delivered", iif(IsDate([T_Date])=Yes,
"Ordered', iif(IsDate([S_Date])=Yes, "Approved","Waiting Approval")))

Thanks in advance

Regards

Memory