question

DTJG avatar image
DTJG asked

Multiple IF and OR Statements in an expression.

I am trying to simply clear a field given a few conditions. If the date falls in the 3 days, yesterday, today and tomorrow, AND the record has a certain LOC value and a specific OrdStatusDesc value. Below is what I have and oddly enough it runs without error but it does not remove the dates at all.

=IIF((Fields!promise_dt.Value = dateadd(dateinterval.Day,+ 1,Today())) or

(Fields!promise_dt.Value = dateadd(dateinterval.Day,- 1,Today())) or

(Fields!promise_dt.Value = dateadd(dateinterval.Day,+0,Today())) OR

(Fields!loc.Value = "MOD") OR

(Fields!OrdStatusDesc.Value = "Pick Ticket Printed")

,Fields!promise_dt.Value,"")

ssrs-2008reportingvisual-studio-2010
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.