We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Calculate the Number of Days Between Two Dates


1 comment

  • Avatar
    Gerry Mullin

    The Aggregate you're using is probably grouped by the CUSTOMER_ID but your order dates might not be in order? I would sort the data by CUSTOMER_ID and OrderDate, then group it by CUSTOMER_ID so you know the firstInGroup will be the first order and lastInGroup will be the latest order from that customer. Attached is an example that I think will help.


    Attached files

    Customer Order Dates - 11 Mar 2020.lna


    Comment actions Permalink

Please sign in to leave a comment.