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

    TOP CONTRIBUTOR
    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,

    Regards,

    Lori Holmes
    LHOLMES@hamamatsu.com



    ------------------------------
    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.

    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


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