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

Comments

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

     

    0
    Comment actions Permalink

Please sign in to leave a comment.