Hi there,

I have an entity with a start date and a term in months. I need to create a query that will return me all rows that have surpassed their term.

eg. I have a start date of 2007-01-01 and my term is 6 months, I need the query to add the 6 months to the start date and determine if it is before the system date. This needs to be done for every row in the table.

Anyone have ideas how this can be achieved, if at all.

Thanks in advance.