CODEWITHSUNDEEP
reporting-servicesexpressiondateadddate-math
Jeff
Jeff

Reputation: 8148

Date Math in Reporting Services Expression

I'm trying to add days to a date and then compare to see if it's outside a range to color code a cell. It's not working--I think I may be making a simple syntax error.

iif(
  (DateAdd("d", CInt(Fields!Days.Value), Fields!Date.Value) < Now), "Red", "White")
)

Upvotes: 0

Views: 3072

Answers (2)

Matt Hamilton
Matt Hamilton

Reputation: 204209

Are you starting your expression with an "=" sign?

=iif(
    DateAdd("d", CInt(Fields!Days.Value), Fields!Date.Value) < Now, 
    "Red", "White")

Upvotes: 1

Ricky Allman
Ricky Allman

Reputation: 36

It looks like you have an extra ")" at the end.

=iif((DateAdd("d", CInt(Fields!Days.Value), Fields!Date.Value) < Now), "Red", "White")

Upvotes: 2

Related Questions