Forum Discussion
Checking Previous Date
Hi
Every day I get a report that contains list of materials and updated delivery date of these materials (see table below)
Item# is unique number for each material
Arrival Date: Is the date when the item will arrive to warehouse.
Update File Date: The date of the Update file.
Arrival Date Change: This is a column that I would like to add where I show the change in delivery date. It will subtract the arrival date - in previous update file - from the latest arrival date -in the latest update file-.
Latest Arrival Date Change: This captures the arrival date from the Latest update file.
Just two notes here:
1) Looking at item # 82012969. The item is not present in 2022-09-06 file. Hence, the latest date would be 2022-09-05 and it will compare it with previous file update.
2) Looking at the same item # 82012969 (and others). The updates don't come daily. You can see update file on 2022-09-05 and the previous one is on 2022-09-02
| Item# | Arrival Date | Update File Date | Arrival Date Change (days) | Latest Arrival Date |
| 30221296 | 2022-09-13 | 2022-09-06 | 0 | 2022-09-13 |
| 30221296 | 2022-09-13 | 2022-09-02 | 0 | 2022-09-13 |
| 30221296 | 2022-09-13 | 2022-08-31 | 0 | 2022-09-13 |
| 30221296 | 2022-09-13 | 2022-08-30 | 0 | 2022-09-13 |
| 30221296 | 2022-09-13 | 2022-08-29 | 0 | 2022-09-13 |
| 72709067 | 2022-09-21 | 2022-09-02 | 0 | 2022-09-21 |
| 82012969 | 2022-10-01 | 2022-09-05 | 1 | 2022-10-01 |
| 82012969 | 2022-09-30 | 2022-09-02 | 1 | 2022-10-01 |
| 82012969 | 2022-09-30 | 2022-08-31 | 1 | 2022-10-01 |
| 82012969 | 2022-09-30 | 2022-08-30 | 1 | 2022-10-01 |
| 82012969 | 2022-09-30 | 2022-08-29 | 1 | 2022-10-01 |
| 82013414 | 2022-10-03 | 2022-09-06 | 17 | 2022-10-03 |
| 82013414 | 2022-09-16 | 2022-09-02 | 17 | 2022-10-03 |
| 82013414 | 2022-09-16 | 2022-08-29 | 17 | 2022-10-03 |
Anonymous ,based on what I got
two new columns
Lastest arrival date = maxx(filter(Table, [Item #] = earlier([Item #]) ) , [Arrival Date])
Diff = datediff([Arrival Date], [Lastest arrival date], day)
1 Reply
Anonymous ,based on what I got
two new columns
Lastest arrival date = maxx(filter(Table, [Item #] = earlier([Item #]) ) , [Arrival Date])
Diff = datediff([Arrival Date], [Lastest arrival date], day)