Steve. Check the format of Sysdate against the format of C_ED.EFFDT. That might be where the problem lies. Everything else looks ok to me. By the way, your name seems familiar to me, do I know you? Access Number: (877) 453-8931