Loading

dummy order tracking

sushmita nandy

how can i assign parcel or product_name to calender function so that a specific amount of days are allocated to that specific product and everyother day the allocated date are decremented for eg if i assign a product with 5 days then every day it should decrement and at end date it should say product delivered....

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke10y ago
From the look of it, I don't think you have to keep decrementing the value every day.
In a table have a product dispatched date and in another column have expected delivery days. If you add "expected delivery days" to "dispatched date" and the result is today's date, then it is delivered.
You can do all of this in sql query. Simple.