CODEWITHSUNDEEP
reporting-servicescolorsformat
AceAlfred
AceAlfred

Reputation: 1191

Reporting services conditional format

This is probably a easy fix for a reporting wiz:)

I want to mark a row red if it is older than current month.

Go to BackgroundColor Expression:

My expression: =IIF(Month(Fields!Date.Value)< Today(Month()),"Red","White")

Fields.Date.Value is on the following format: (DD/MM/YYYY)

Already looked through similar posts and could not find any suitable help.

Upvotes: 0

Views: 743

Answers (1)

Chris Latta
Chris Latta

Reputation: 20560

Check that the date is less than the start of this month:

=iif((Fields!Date.Value < DateAdd("d", 1-Day(Today()), Today())), "Red", "White")

Upvotes: 1

Related Questions