SQL Server Performance Forum – Threads Archive
Day specific reportsI have a report that I want to do an iif for the day, so that on monday, the background is green, but the rest of the days are red, can i do that? something that would take this psuedocode and make it work
=iif(datepart(day) = "Monday", "Green", "Red’) Joe Janka
You can enter the Iif statement into the format properties for the cell/text box. The datepart function requires two input, the part and the date to take it from. I think RS will accept "DW" as the part – though this will return 1-7 rather than the text day. Hope that helps!