Ok. I have a table in Mysql that has a field that is a date datatype named due_date. As you probably already know, Mysql date fields store dates in the format yyyy-mm-dd. I need to run a query from coldfusion that finds dates in this field that are 30 days older than today. In coldfusion now() - 30 should accomplish this. I can't seen to get the query right to accomplish this. I have done this in Oracle before but the date field in Oracle is formatted differently. I need to know how to structure this query.