Datetime range

Finance and Operations/AX Developer Forum
1

Hello guys I have a trouble with the ime ranges.I add my ranges blok at the datasource’s query:

qbrBuzCrdtPaybackDate.value(queryValue(BuzCrdtPaybackDate));
qbrPayback.value(queryValue(Paybackk));

this is my datasource’s init also:

qbrBuzCrdtPaybackDate = this.query().dataSourceTable(tablenum(BuzCrdtLinePayback)).addRange (fieldnum(BuzCrdtLinePayback,BuzCrdtPaybackDate));

qbrPayback = this.query().dataSourceTable(tablenum(BuzCrdtLinePayback)).addRange (fieldnum(BuzCrdtLinePayback,Payback));

but it brings only the selected date to form.Not just only the one date’s values but I have to bring to all values from beginning to selected date from the dialog.

how should change this line:qbrBuzCrdtPaybackDate = this.query().dataSourceTable(tablenum(BuzCrdtLinePayback)).addRange (fieldnum(BuzCrdtLinePayback,BuzCrdtPaybackDate));

2

I assume that BuzCrdtPaybackDate and Paybackk are date values, so you’re indeed setting a range for these dates only. If I understand you correctly, you want something like <MyDate instead of =MyDate, right?
One of possible ways is queryRange(dateNull(), Paybackk)).

3

not exactly payback is not a date value.I want something like <=Mydate

4

Then please tell us what it is - we can’t read your mind.
But it seems that queryRange() is an answer anyway.

5

just ı want to bring the datas <=mydate.(from first record to mydate).if I add only qbrP.value(queryValue(mydate));
it brings only the selected date’s lines from dialog but I want to see all lines’ untill the mydate

6

Have a look at \Classes\SysQueryRangeUtil\lessThanDate

7

but I have to bring not 2-3 days before or month I have a specific date I cant use sysquery::range(mydate) like that

8

Have you at least tried the code in my reply (queryRange(dateNull(), myDate))? You seem to ignore it.

9

I am not asking you to use that, but look at how the date is concatenated with ‘<’ (by using SysQuery::value) and same can be used in the range value.

10

sorry martin I could not understand at first ,I will try it

11

thank you so much martin it worked.I was trying to 01.01.1990,mydate somethinglikethat(imposibble date to-mydate ) but datenull is more smarter idea thank yo somuch again