Hi Everyone,
I got a scenario where, I was supposed to calculate the date type from the date where it needs to be added.
Ex:
Load * inline [
Item, DOP, Day, DOE
Milk1, 01/01/2018, 10
Milk2, 02/01/2018, 2
Milk3, 03/01/2018, 5
Milk4, 04/01/2018, 1
Milk5, 05/01/2018, 1
Milk6, 06/01/2018, 3
];
DOP: Date of Purchase, Days: Number of days the product will stay fresh/no of days to expire, DOE: Date of Expiry
Question:
I was supposed to use a straight table to display Item as dimension and DOE [by adding DOP + days]. Once I get the DOE, I have to sort the data according to DOE [The 1st product in the list is which to be expired first].
Please help me as I was not able to do so.
