borders in different for the current date in between dates

[PeriyurParthi]

dear all,
i need to differentiate the the records which are all satisfying the codition of Current day(date) . ie i have a report on employee database of particular month. when the DOB field datas falls on current date the whole record color has to be indicated in diffrent color. i tried out with section report-details-color-background color- and by giving formula as
day({EmpMaster.DOB})=day(CurrentDate)

but it is showing error as "Formula result must be a number".
please help me to solve this problem. replies will be appreciated. thanks
periyur

 

[bdreed35]

You are getting the error because you need to specify a color to use when the condition is met.
Try this to turn the detail line yellow when your condition is met:

If day({EmpMaster.DOB})=day(CurrentDate)
    crYellow
Else
    crNoColor

You can change the crYellow to something else under the Color Constants in the Formula Editor or create a custom color using

Color(200,200,200)

You can adjust each number from 0 to 255 to control the amount of Red,Green,Blue. The example that I used above is a shade of gray.

~Brian

 

[PeriyurParthi]

thanks a lot brian