[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

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

Asked by dmrs in ColdFusion Application Server, ColdFusion Studio

Tags: cold fusion 8

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 
1:

WHERE  #form.tod# BETWEEN #createODBCdatetime(form.Sdate)# AND #createODBCdatetime(form.Edate)#
[+][-]10/09/09 05:22 PM, ID: 25539890Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-92 - Hierarchy / EE_QW_3_20080625