Weird Date Format being passed in my Report URL?
I have a simple cfm page with three Form elements: startDate, endDate, and a Spry Menu with links to my seven reports.
I have added "Parameters" for the form.startDate & form.endDate and passing them to the Reports in my Spry menu dropdown.
- Here is a sample Report URL after clicking a report in my Spry drop-down:
http://192.168.1.77/DailySalesReport/reports/01_DSR_Mgt_Report_by_Sales.cfr?startDate={ts '2011-05-06 00:00:00'}&endDate={ts '2011-05-06 00:00:00'}
- What is causing the weird Start & End Dates that have the "{ts" name & brackets?
- Why are my Dates typed in above on my Form page not being forwarded in the Report URL?
Note: In testing, If I use a normal Submit button on the page (see Daily Sales button below), to run a report, it works fine and the parameters are passed to the report and the report prints just the data for April.
- Here is the Full Code listing for the page: http://cerberus.clearwave.com/jerry/SalesHTML.txt
http://forums.adobe.com/servlet/JiveServlet/showImage/2-3650969-67272/report prompts.jpg
- I'm using DW CS4 & CF 7.02
- All of my Reports are created in Cold Fusion Report Builder using Parameters like this:
- WHERE tblSalesCatg.scID IN ('1', '2', '3', '4','5', '6', '7','8', '9', '10') AND DATE_FORMAT(tblSalesReport.srCompDate, '%m/%d/%Y') BETWEEN '#param.startDate#' AND '#param.endDate#'
AdChoices