|
Hi, Im creating a table which will record the current (order date) and also predict a delivery week ending date. For example: the order date will be entered into my table as CURRENT_DATE(). The delivery week ending date will be 3 weeks on friday. Can anyone show me how i can work this so my predicted delivery date will always be a friday please?
Thanks in advance
|