How to filter a dynamic date range in Microsoft Dynamics AX

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.

First we click on the filter symbol in the left margin of "All Purchase orders" and we "add a filter field". Now we enter the letter "T" or "t" in the "Delivery date" to see all PO's to be received after today.

 

2. Use the command (dayRange(-3,7)) to filter transactions with a delivery date between 3 days before today and 7 days after today. Make sure to use "matches." In the below example, we use the range 10 days before today and 10 days after.

 

 

<... class="become-member ms-auto me-auto">