Re: Date Comparison Help

Perfect and thank you so much for the swift response;

At 04:23 PM 4/8/2004, Mike Nolan wrote:

> I need a query to get data that is 6 months older than "today" or when that
> query is run.

WHERE table.date < current_date-interval'6 months'
--
Mike Nolan

---

		Brian C. Doyle
		Director, Internet Services
		United Merchant Processing Association
		http://www.umpa-us.com
		1-800-555-9665 ext 212