I am looking for some SQL assistance in retrieving records based on date arithmetic.

I have a date type column called 'ENTERDATE', and at a simple level I require to return all records that have a date that is between now eg 2-Jan-2007 and the previous 1-July. eg 01-Jul-2006.

If I were to run this query say Dec 2007, then the range would be
01-Jul-2007 and say 25-Dec-2007.

I know I can use parameters and just type in a to_date..... however i am looking for a calculation which would not require editing of the date range in the query.

Thanks