I am working on some logic to compare two dates, of the order type "outbound" if the dates do'nt match then I need to apply a yellow background to both cells. if one of the two dates is null, no yellow background should be apply.
i tried this, but is not working:
Fields!Type.Value = "Outbound" AND
Fields!NAVShipmentDate.Value <> "" AND
Fields!NAVShipmentDate.Value <> Fields!TranDate.Value, "Yellow", "White"
i highlighted the cells that should be yellow based on logic. i hope someone can help me with this logic.
thank you much.