I have one field with Snapshot Date for the current month and another field for Projected Delivery Date. I want to create a table of only the Order Numbers that have changed Projected Delivery Dates to the next month.
Say for example:
Order Number Snapshot Dates Projected Delivery Date $ Value
1101 1 19-Aug $1,000
1101 2 19-Aug $1,000
1101 3 19-Aug $1,000
1101 4 19-Aug $1,000
1101 5 31-Aug $1,000
1101 6 5-Sep $1,000
I want to create a table for the red row, for all the order #'s that have changed their Projected Delivery Date to the next month. What is the best way to go about this?
Thanks!