sql server reporting services: Will something like this work for you?

=iif(Fields!EventDate.Value < dateadd("n", -10, Now()), "Red", "Black")

Regards,

Dan

Not a problem. Glad it worked.

I am building a report with a query that includes a field of type datetime.
I would like to change the color of the text in this column to RED if the
value contained in the field is earlier than now() - 10 minutes. I would
appreciate direction as to the appropriate function to use in this scenario.
I have tried to work with datediff, but without positive results.

Regards,

Pete Zerger, MCSE(Messaging)
Co-founder and Webmaster, MOMReourcs.org
URL:http://www.momresources.org
mailto:pete.zerger@gmail.com

Hello Dan,

Close. This seems to return the word RED or BLACK in the target field rather
than just changing the color of the text.

Regards,

Pete Zerger, MCSE(Messaging)
Co-founder and Webmaster, MOMReourcs.org
URL:http://www.momresources.org
mailto:pete.zerger@gmail.com


[quoted text, click to view]

Hello Dan,

Pardon my ignorance Dan, I pasted this expression into the wrong field. This
in fact worked perfectly. Thanks so much for your assistance.

Regards,

Pete Zerger, MCSE(Messaging)
Co-founder and Webmaster, MOMReourcs.org
URL:http://www.momresources.org
mailto:pete.zerger@gmail.com


[quoted text, click to view]