Hi,
I have added a conditional formatting in one of my report to make red a date if it is older than 30 days:
=Field.StatusDate <= = Now().AddDays(CDBl(-30))) then I apply the style : background = red
The above is working fine and I get the desired result.
My problem now is to exclude from the above conditional formatting the values having "Field.StatusDate older than 30 days" where the "Field.Status" value is ="B"
Can some one help please?
Thank you,
Felice
I have added a conditional formatting in one of my report to make red a date if it is older than 30 days:
=Field.StatusDate <= = Now().AddDays(CDBl(-30))) then I apply the style : background = red
The above is working fine and I get the desired result.
My problem now is to exclude from the above conditional formatting the values having "Field.StatusDate older than 30 days" where the "Field.Status" value is ="B"
Can some one help please?
Thank you,
Felice