Is this the same as the other thread asking this? I remember someone advising someone else to put {} around the date. I think what that person meant is when you define the tdDateTo make sure you use the {}.

-Michelle

>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.