I'm trying to create a report of our activity in a period.
I've added 2 objects (vfrom, vto) text format 13-01-2007.
If I run activity and fill in the 2 dates ex. vfrom = 01-01-2011 and vto = 17-05-2011, the report shows other dates (1-10-2000 and 11-10-2016).
my sql is
Code: Select all
$sql = "
CREATE TABLE #dataTable# SELECT count(r.act_duur) as aantal, g.gev_gevangenis, m.mod_module FROM activiteiten r, gevangenis g, module m where gev_id = act_gevangenis and m.mod_id = r.act_module_id and r.act_datum between '#vfrom#' and '#vto#' group by g.gev_gevangenis, mod_module"
;
nuRunQuery($sql);
Any idea what's going wrong.
Regards
Johan