where custTrans.TransDate <= perDate
&& (custTrans.Closed == dateNull() || custTrans.Closed > perDate)
qbdsCustTrans.addRange(fieldNum(CustTrans, TransDate)).value(queryRange(null, perDate));
qbdsCustTrans.addRange(fieldNum(CustTrans, Closed)).value(queryValue(dateNull()));
qbdsCustTrans.addRange(fieldNum(CustTrans, Closed)).value(strFmt('>%1', queryValue(perDate)));
André Arnaud de Cal...
292,111
Super User 2025 Season 1
Martin Dráb
230,934
Most Valuable Professional
nmaenpaa
101,156