Re: Date Comparison

Edd, One possibility is during the select statement: select sysdate ,trunc(sysdate) - 2 ,to_date( '28-AUG-2001' ) - (trunc(sysdate) - 2) ,to_date( '27-AUG-2001' ) - (trunc(sysdate) - 2) ,to_date( '26-A

RE: Date Comparison

Use Date::Manip >From the docs... Among other things, Date::Manip allow you to: 1. Enter a date and be able to choose any format convenient 2. Compare two dates, entered in widely different formats to determine which is earlier 3. Extract any information you want from ANY date using a form