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
Thanks Dick I got my result
I Just Put the Local in query thanks for identifying
Thanks Dick
Yes it is control on form and EDT is TransDate and I droped Display Method on grid
to calculate amount
I assume that txtDate is a control on a form?
is this one of EDT type TransDate?
also
select sum(AmountCur) from vendTransLocal
where vendTransLocal.AccountNum==_VendTrans.AccountNum && vendTransLocal.AmountCur<0
&& vendTransLocal.TransDate <= TxtDate.dateValue();
VendTotalCredit = vendTransLocal.AmountCur;
return VendTotalCredit;
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156