<div>
SELECT field FROM table WHERE due_date = '#DateFormat( DateAdd( 'd' , -30 , now() ) , 'yyyy-mm-dd' )#'<br />
( perhaps you don't have to enclose date in single quotes )<br />
<br />
or use sql's DATEADD - this is Ms-SQL how ever, so the function may differ...<br />
<br />
SELECT field FROM table WHERE due_date = DATEADD( Day , -30 , getDate() )<br />
<br />
cheers
</div>


SELECT field FROM table WHERE due_date = '#DateFormat( DateAdd( 'd' , -30 , now() ) , 'yyyy-mm-dd' )#'
( perhaps you don't have to enclose date in single quotes )

or use sql's DATEADD - this is Ms-SQL how ever, so the function may differ...

SELECT field FROM table WHERE due_date = DATEADD( Day , -30 , getDate() )

cheers

<div>
CFQUERYPARAM usually solves most date/time problems with databases<br />
<br />
&lt;cfquery ...&gt;<br />
SELECT field FROM table WHERE due_date = &lt;cfqueryparam value=&quot;#DateAdd('d',-30,no<wbr />w())#&quot; cfsqltype=&quot;cf_sql_date&quot;&gt;<br />
&lt;/cfquery&gt;<br />

</div>


CFQUERYPARAM usually solves most date/time problems with databases

<cfquery ...>
SELECT field FROM table WHERE due_date = <cfqueryparam value="#DateAdd('d',-30,now())#" cfsqltype="cf_sql_date">
</cfquery>


<div>
Strange... you specified &quot;30 days older than today&quot;, not at least 30 days older...
</div>


Strange... you specified "30 days older than today", not at least 30 days older...

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


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.

ColdFusion Mysql date query problems

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.

Web Servers

Web development software is used to create websites for both the Internet and intranets. Software can be either locally installed or operated through a cloud interface, and ranges in complexity from simple text editors to full-fledged integrated development environments (IDEs) that include graphics, video, audio, scripting and database support.