PHP код:
Query q = new Query();
querybuilddatasource qbds;
;
qbds = q.addDataSource(tablenum(ledgertrans));
qbds.addrange(fieldnum(ledgertrans,transdate)).value(sysquery::range(01\01\2003,systemdateget()));
box::info(qbds.toString());
Говорит
SELECT * FROM LedgerTrans WHERE ((TransDate>=01.01.2003 AND TransDate<=01.07.2003))