How to change crystal report row forecolor base on dates

Question

I am using vb.net , mysql as backend, crystal report as reporting. How can i change the row forecolor in my crystal report according to date. For example, all August 1 would be blue, August 2 would be red, august 8 would be blue and so on. Thank you in advance.

Answer 1

Right click the report object (Text object) -> click Format Object. Click the Font tab. Then click the Formula Editor button to the right of the Color selection dropdown box.

I use Basic Syntax because it's closer to VB.Net

if Day(<name of your column>) = 1 then
    formula = crBlue
elseif Day(name of your column) = 2 then
    formula = crRed
end if