filter the data in between two dates

Finance and Operations/AX Developer Forum
1

how can i to filter the data between two dates by using query build data source?

2

can any one help me?

3

queryRun.query().DataSourcetable(tablenum(tablename)). addRange(fieldnum(tablename,datefield1)).value(queryValue(startDate));

queryRun.query().DataSourcetable(tablenum(tablename)). addRange(fieldnum(tablename,datefield2)).value(queryValue(EndDate));

4

for from date and to date is it ok?

5

if u want to filter the data on one field the use this

queryRun.query().dataSourceTable(tablenum(tablename)).
addRange(fieldnum(tablename,Datefield)).value(queryRange(startDate,endDate));

6

Hi Ven,

try below,

qbs.addRange(fieldnum(tableName,fieldName)).value(QueryValue(fromDate)+ ‘…’ + QueryValue(todate));