[Lori Holmes]

Hello everyone…

First, I HOPE everyone is healthy.

I am looking for some assistance.  We use Release Sales Order Picking to process orders in our shipping department.  We’d release picking lists based on a certain criteria.  One of these criteria is using the Confirmed Ship date.  I know I want the date range to start at the earliest date we have orders confirmed in the system…we use 1/1/2000 in an effort to catch dates which may have been fat fingered.  The tricky part (for me) is the end date expression.  I want the expression to close at ‘2 weeks from today or 10 days from today’.  Does anyone have a list of date expressions that may work OR does anyone know the best way to handle this expression?

Thank you so much in advance,

Regards,

Lori Holmes
LHOLMES@hamamatsu.com

——————————
Lori Holmes
Hamamatsu Corporation
Bridgewater, NJ
——————————

[Phil Dawson]

Hi Lori,

The below expression in the date field should give you everything from the beginning to 10 days from today.

.. (Day(+10))

You can see this described right at the bottom of the link below.

https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/advanced-filtering-and-query-options

Hope this helps.

Cheers
Phil

——————————
Phil Dawson
Sunpork Fresh Foods Pty Ltd
——————————
——————————————-