Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help: "Outputing a date range from a query"

Status
Not open for further replies.
lminmei

lminmei

Programmer
Feb 1, 2000
111
0
0
US
I have a query from a database with records that contain dates<br>on my output page..i want to display a range: <br>(earliest date from query) to (last date from query)<br><br>how would i go about doing this?
 
Sort by date Sort by votes
<FONT FACE=monospace><b>&lt;cfset date1=&quot;1/1/2000&quot;&gt;<br>&lt;cfset date2=&quot;6/1/2000&quot;&gt;<br><br>&lt;cfquery datasource=&quot;mydb&quot; name=&quot;daterange&quot;&gt;<br>SELECT * FROM MyTable<br>WHERE Date &gt; '#date1#'<br>AND Date &lt; '#date2#'<br>&lt;/cfquery&gt;</b></font><br><br>Hope this helps...
 
Upvote 0 Downvote
Use order by in your select statement and then in you rcfoutput, set the start date from the first record and the end date from the last record.<br><br>&nbsp;&nbsp;&nbsp;&nbsp;Regards,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dave Joyce<br><br>
 
Upvote 0 Downvote
Dave,<br><br>How would I go about setting the start date to the first record and the end date to the last record?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

RBGraphics
  • Locked
  • Question
Adobe Portfolio
Replies
0
Views
108
RBGraphics
RBGraphics
fdgsogc
  • Locked
  • Question
Displaying results of an SQL Pivot Query
Replies
1
Views
130
jdhilljr
jdhilljr
LyndonOHRC
  • Locked
  • Question
Need help using ImageCrop()
Replies
1
Views
43
LyndonOHRC
LyndonOHRC
MDEJAKE
  • Locked
  • Question
autosuggest (cfc and jquery) help
Replies
0
Views
52
MDEJAKE
MDEJAKE
Mike Lewis
  • Locked
  • Question
Using Dreamweaver to maintain a site not created in Dreamweaver
Replies
2
Views
140
Mike Lewis
Mike Lewis

Part and Inventory Search

Sponsor

Back
Top