This content has been marked as final. Show 2 replies
Try IF [Date] > #2014/07/01# AND ISNULL([Resolution ID]) THEN 1 ELSE 0 END
The date syntax will need to be in a specific format.
Pooja to the rescue again!
That worked like a charm once I made sure the date format was in the correct syntax.