Report Studio Projected Delivery Date Change

[kmcgilli]

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!