Hi,
I have a report that takes data from two different IT systems and highlights where there are differences. Most of the data is dates.
This works OK where there are two dates i.e. if they're different it highlights both and if they're the same it doesn't.
But if one date is missing, then my conditional formatting doesn't work.
I've used Expression is: [Last_SSI_Validated]<>[SSI_Submission_Validated]
Is there an easy way to change that to make it work if one or other date is missing? If they're BOTH missing, then that's not an issue (as it's non-mandatory data) so I would not want highlighting in that case.
Attached jpg may give more of an idea of what I'm trying to achieve.
Thank you
I have a report that takes data from two different IT systems and highlights where there are differences. Most of the data is dates.
This works OK where there are two dates i.e. if they're different it highlights both and if they're the same it doesn't.
But if one date is missing, then my conditional formatting doesn't work.
I've used Expression is: [Last_SSI_Validated]<>[SSI_Submission_Validated]
Is there an easy way to change that to make it work if one or other date is missing? If they're BOTH missing, then that's not an issue (as it's non-mandatory data) so I would not want highlighting in that case.
Attached jpg may give more of an idea of what I'm trying to achieve.
Thank you
