Hi All, Needing some help on displaying the orders where the status has changed when compared to the previous day. Table on the left showing 2 Order ID's and the table on the right only retur...
So what I'm getting at is using the MAX(Today's DT) and compare each order with previous Today's Date < MAX(Todays DT) and check to see if anything on the order has changed (Status in this example). Hope this image clears it up
