How do I prompt for a date range in report?
Posted: Thu Jan 17, 2013 6:04 am
Hi,
I have just created a report that displays all of the rows where vio_date_entered is within a date range.
How do I prompt the user for the beginning and ending date in the date range, ideally using a calendar? Is there a sample I could look at?
Thanks,
John
I have just created a report that displays all of the rows where vio_date_entered is within a date range.
Code: Select all
$sql = "CREATE TABLE #dataTable# SELECT * FROM violations ";
$sql .= "WHERE vio_date_entered > '2012-10-01' AND vio_date_entered < '2012-11-01' ";
$sql .= "ORDER BY vio_date_entered ";
nuRunQuery($sql);
Thanks,
John