At times things seem just too easy, so I want to confirm that this is the correct syntax. I am looking for the interval (aging) for these invoices. I guess I am concerned because I guessed at the syntax. Is there a better way to do this? billdate is type 'date' SELECT ('now'-billdate) FROM fcinvoiced WHERE client = 'smith'; Ted ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster