The following example uses day(-1) to select Customer tax invoice journal records for yesterday
Blog related to Microsoft Dynamics AX
Thursday, July 24, 2014
Dynamic date ranges for queries in AX
In Dynamics AX it is possible to enter dynamic date ranges for queries e.g. currentDate, day(-1) etc. which can be useful for running a daily report via a scheduled batch job.
The following example uses day(-1) to select Customer tax invoice journal records for yesterday
There are a number of dynamic data query values available in AX 2012, which can be found in the SysQueryRangeUtil class
The following example uses day(-1) to select Customer tax invoice journal records for yesterday
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment