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);
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