Rich, You can do date - number, but not number - date. First query fails as it is date - date which is a number and then - date. With parenthesis, it resolves to date - number. Sandeep -- //www.freelists.org/webpage/oracle-l