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