How to filter a dynamic date range in Microsoft Dynamics AX
December 7 2016
Filtering transactions like Purchase orders or Sales orders on a date range is a standard requirement.
I want to see the Purchase/Sales orders that are to be received/shipped today, or in the next x days.
Instead of typing specific calendar dates in our filter (which will certainly work), we would want to enter a date range that adjust itself automatically as time progresses.
Here are two ways of date filtering that work perfectly.
1. Use the letter "T" or "t" for a dynamic "today" filter.
Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here
Learn more about us here