Works intermittently. Have a date column which is the 2nd col in an edittable. Thought I would use %U% as it should do what I require. Works fine on the 2nd row / 2nd col where it prevents me setting duplicate dates. However I can add duplicate dates in row 3 col 2 and subsequent rows with abandon. Do I have to do anything else to make it behave? I have it as a validation in the screen.

Seems to work correctly on Col 1 which holds simple codes. I do have code creating a default date - would that screw it up? Tried it on a simple numeric col. doesn't work there either.

View this thread on the forum...