Dear Expert
Below query date criteria is not working i am getting todate amount from database
please advice on query...Thanks
Afridi
display Amount VendorTotalCreditOnGrid(VendTrans _VendTrans)
{
real VendTotalCredit;
VendTrans vendTransLocal;
select sum(AmountCur) from vendTransLocal
where vendTransLocal.AccountNum==_VendTrans.AccountNum && vendTransLocal.AmountCur<0
&& vendTrans.TransDate <= TxtDate.dateValue();
VendTotalCredit = vendTransLocal.AmountCur;
return VendTotalCredit;
}
*This post is locked for comments