Hi Team,
Please help correct my below simple query in report, which is giving me syntax error, am i silly here:
SELECT max(total)
FROM ‘tabsales invoice’ WHERE posting_date = curdate()
Thanks.
Hi Team,
Please help correct my below simple query in report, which is giving me syntax error, am i silly here:
SELECT max(total)
FROM ‘tabsales invoice’ WHERE posting_date = curdate()
Thanks.
Please apply it.
SELECT max(total)
FROM `tabSales Invoice`
WHERE posting_date = CURDATE();
Another reference: Stock report issue - #4 by NCP
Thanks buddy.