conditional formatting Font in textbox

[jcglenn]

I have a report that sorts sales figure summarys by date and I would like to change colors for Sat and Sun. I tried using a iif statement in the font properties for the textbox.

I receive an error box stating my expression is not a valid color.

iif(datepart(dw,fields!reportdate.value) > 5, Blue, Black)


TIA for your help.

Craig

 

[jcglenn]

OK, part of my problem was I ommited the =

now...
=iif(datepart(dw,fields!reportdate.value) > 5, Blue, Black)

returns error...
The color expression for the textbox ‘ReportDate’ contains an error: [BC30451] Name 'dw' is not declared.

Can I not use datepart() here? if not, please suggest another way to change the font color for Sat and Sun.

thanks,
Craig

 

[jcglenn]

OK got all the kinks out. Works now that I got all the syntax right...

Had to create a new column to extract the Day of the week to get around using datepart() in the iif statement and had to use quotes around the colors.

=iif(fields!DOW.value = 1 or fields!DOW.value = 7, "Blue", "Black")