<div>
That is the correct syntax (more or less). &nbsp;What is the error message and what are the values of the 3 variables? &nbsp;
</div>


That is the correct syntax (more or less).  What is the error message and what are the values of the 3 variables?  

<div>
Good. Don't forget to accept your comment as the answer (and close the question).<br />
<br />
&gt;&nbsp;WHERE &nbsp;#form.tod#<br />
<br />
BTW: &nbsp;You shouldn't use form values in a query like that. It's a sql injection risk.
</div>


Good. Don't forget to accept your comment as the answer (and close the question).

> WHERE  #form.tod#

BTW:  You shouldn't use form values in a query like that. It's a sql injection risk.

<div>
<div class="content wysiwyg-content">
Hi, <br />
I'm trying to query in report builder a date range of 1 week, so what is appears on my report is one week. &nbsp;<br />
No matter what I put in it errors on me. &nbsp;I know its probably something very simple that I'm over looking but any help can't hurt me at this point. <br />
thanks <br />
Dave<br />

<pre><code id="code-427662">WHERE  #form.tod# BETWEEN #createODBCdatetime(form.Sdate)# AND #createODBCdatetime(form.Edate)#
</code></pre>
</div>
</div>


Hi, 
I'm trying to query in report builder a date range of 1 week, so what is appears on my report is one week.  
No matter what I put in it errors on me.  I know its probably something very simple that I'm over looking but any help can't hurt me at this point. 
thanks 
Dave

how to query a week date range in cold fusion report builder?

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.