Skip to Content
0
Former Member
Feb 22, 2009 at 06:08 AM

Color date field background if null

447 Views

Hi,

I have a report with a series of date fields and I need to be able to set a conditional format to highlight the next date field that is null.

I cant even get the fields to return with a highlighted background if null.......once I achieve that then I will work on a case statement to look at each date field and determine if there is a value then look at next field.

This date is pulled from a database that houses data in ClearQuest.

Here is the formula I came up with but instead of highlighting the null fields, it highlights the ones with a value.

if not IsNull({ChangeRequest.client_cr_loe_provided_dt}) then cryellow