D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

AX 2012 RTM Help with Date Expressions

  • 1.  AX 2012 RTM Help with Date Expressions

    Posted Mar 31, 2020 05:01 PM
      |   view attached

    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,


    Lori Holmes

    Lori Holmes
    Hamamatsu Corporation
    Bridgewater, NJ
    Academy - Online Interactive Learning from Experts

  • 2.  RE: AX 2012 RTM Help with Date Expressions

    Posted Mar 31, 2020 06:08 PM
    Edited by Phil Dawson Mar 31, 2020 06:33 PM
    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.


    Hope this helps.


    Phil Dawson
    Sunpork Fresh Foods Pty Ltd

    Academy - Online Interactive Learning from Experts

If you've found this thread useful, dive deeper into User Group community content by role