Comparing sysdate()-1 to another date in multiple datasets in a report document.

[dinzana]

I have two data sets in a report document.

R1) Date attribute with a metric value of sysdate()-1 which shows up as 20120626 for today
R2) Date attribute with a metric value of maxExecutionDate which shows up as 20120625 for today

What i am trying to do is create some conditional format to show an image if maxExecutionDate is = sysdate()-1

Is this possible?

I cannot add the sysdate()-1 metric to R2 as it comes from an intelligent cube, and I cannot create a derived metric for sysdate()-1 either.

Any ideas?

Thanks,

dinzana