AX - Build-in functions for filters

For filters in AX you can use build-in functions:

• (today()) - current day.
• (day(-1)) - yesterday.
• (day(1)) - tomorrow.
• (day(-4)) - current day -4 days.
• (dayrange(-7,7)) - date interval -7 days .. +7 days.
• (monthrange(-1,-1)) - like previos, but months.
• (yearrange(0,1)) - like previos, years.
• (lessthandate(-5)) - less than current day -5 days.
• (greaterthandate(5)) - greater than current day +5 days.

More advanced functions (class SysQueryRangeUtil):

• (currentWorkerRecId()) - db recid of current user.
• (getActiveMasterPlanVersionByPlanId( "MAINPLAN" )) - returns master plan.
• (documentStatusPurchOrderOrGreater()) - purchase order status  DocumentStatus::PurchaseOrder or high.
• (currentWorker()) - HcmWorkerRecId of current user.
• (currentUserLanguage()) - language of current user.
• (currentUserId()) - current user.

+ several more.