Вариации на тему...
X++:
Query reportQuery = new query();
QueryBuildDataSource qbds = reportQuery.addDataSource(tablenum(LedgerJournalTable));
date dateFrom = 01\01\2014;
date dateTo = today();
queryRun queryRun;
;
qbds.addRange(fieldnum(LedgerJournalTable, ReverseDate)).value(queryRange(dateFrom, dateTo));
qbds.addRange(fieldnum(LedgerJournalTable, ReverseDate)).value(queryvalue(dateNull()));
info(qbds.toString());
queryRun = new SysQueryRun(reportQuery);