Hi Nancy,I need your help
I have this SQL statement.I want that tdDateTo(in the AND statement) takes the value of tdDateTo(of the BETWEEN statement).I did try with
{tdDateTo} in the AND statement but the field appears like this{/ /},and not shows the wanted values.
What's wrong in the structure ?
SELECT a.date, a.concept, SUM(a.amount) AS n_impo, a.quotas ;
FROM Master a ;
WHERE BETWEEN(a.date,tdDateFrom,tdDateTo) ;
OR a.plan = .T. ;
AND a.date <= {tdDateTo} ; ---->>>> this
AND ALLT(a.quotas) <> "0" ;
ORDER BY a.date ;
GROUP BY a.nro_oper ;
INTO CURSOR c_names
TIA.
Thanks in advance