Are there any other ways. My thing is, A due date is manually entered, and when the task is completed, the complete button is clicked. The I have a relationship in another file for only the head person to see the due date and the completed date. The date calculation is: if (due date < complete date) then another field says "Late", or else says "on time". Probably real simple, but I don't understand the {Case(not YourField = "complete", Date(LeftWords(YourField, 1), MiddleWords(YourField, 2, 1), RightWords(YourField, 1)) ]
I'm not that advanced yet. I hope that makes more sense,
Scott