Using COUNT() in report

[apmuthu]

Acquire the date fields input as you want but send it (save it) in MySQL ANSI format - yyyy-mm-dd. All JS in the form gets lost when used to run a report.

[icoso]

Acquire the date fields input as you want but send it (save it) in MySQL ANSI format - yyyy-mm-dd. All JS in the form gets lost when used to run a report.

I did that. I moved this convo to this post: https://forums.nubuilder.cloud/viewtopic. ... 2&start=10

Can you help me there? The long last post covers a lot of questions...

[steven]

icoso,

Code: Select all

SELECT TaxCustomers.* FROM TaxCustomers WHERE TaxCustomers.tax_billdate BETWEEN '#RPT_date1#' AND '#RPT_date2';

should be

Code: Select all

SELECT TaxCustomers.* FROM TaxCustomers WHERE TaxCustomers.tax_billdate BETWEEN '#RPT_date1#' AND '#RPT_date2#';

Steven

[icoso]

Yes, I have that. That was just a Typo in this forum post. As I mentioned in the other post in the Reports thread. I got it working - not the way the manuals, wikis, videos, examples show you how, but I got it working. The SQL is working now, but I had to call it and the report from a launch form.

HOWEVER, I still can't get the date variables passed into the report itself. They don't print on the report. I posted pictures.