Hi,
Many thanks for taking the time to read and hopefully provide me with some help and understanding.
so my database is as below - there is alot more to it but to make it simpler to explain i will only show relevant info.
database name - parcel_tracking
ID | parcel_ID | Parcel_Status | Date
1 | 1234 | Picked | 2022/01/01
2 | 2345 | Picked | 2022/01/01
3 | 1234 | Packed | 2022/01/08
4 | 2345 | Packed | 2022/01/09
5 | 1234 | Delivered | 2022/01/09
So i need to find each parcel that meets 2 status, so lets say every parcel thats been picked and packed for this example and also the number of days between each event as below
Parcel_ID | Pick_Date | Pack_Date | Delay
1234 | 2022/01/01 | 2022/01/08 | 7
2345 | 2022/01/01 | 2022/01/09 | 8
All info is in the same table, i will also be pulling data within a date range so say the 1st of a month to the last of the month to check delivery performance.
Any help would be massively appreciated.
Thank you.
Mike