Below i have six order lines, but i only want to have one order line with the earliest date as the output which means the output should be only one order line with 12/1/2019.
Inner Join (Order) LOAD ITEM, Min(Date) as Date Resident Order Group By ITEM;
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Inner Join (Order) LOAD ITEM, Min(Date) as Date Resident Order Group By ITEM;
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
