Here is the solution I put together. Any comments on how this could be simplified.
<cfscript> currentDate = arguments.beginDate; dateString = "SELECT TO_DATE('" & dateFormat(currentDate,"mm/dd/yyyy") & "', 'mm/dd/yyyy') AllDates FROM DUAL"; currentDate = dateAdd("d",1,currentDate); while (dateCompare(currentDate,arguments.endDate) LTE 0) { dateString = dateString & " UNION "; dateString = dateSTring & "SELECT TO_DATE('" & dateFormat(currentDate,"mm/dd/yyyy") & "', 'mm/dd/yyyy') AllDates FROM DUAL"; currentDate = dateAdd("d",1,currentDate); } </cfscript> -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223190 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54