I need to get a snapshot to find the earliest order date that was still open for each week.
First I assigned the week ending that coorelates with the order date then I located the earliest order date by manually reviewing each week if the order was still open or not and if not then I pulled...