how to fetch last one week transactions in x++?

Dynamics 365 for Finance and Operations/AX Developer Forum
1

any on reply me

2

what transactions you are talking about? Do you have a date on the transactions?

please elaborate.

3

yes i have field on the table which represents (Transdate) .

4

To get last seven days (what ever the number) from today, minus the number of days from today

Example:

TransDate fromDate = systemdateget() - 7;

while select youtTable

where yourTable.TransDate >= fromDate

&& yourTable.TransDate < systemdateget()

You can also use query framework for this.