VP-ASP New User
Posted - August 04 2002 : 05:09:20
| I have added a field to the orders table called 'pdate'
in shop_displayorders.asp i have found
Sub MarkProcessed (Item)
'Response.write "item=" & item
sql= "update orders set oprocessed = 1 where orderid =" & item
how can i modify the sub so that it also adds the current date to the field 'pdate'??
This is needed to help us comply with parts of the EU Distance selling directive, there is the following condition to which we have to adhere to:
"The consumer has the right to cancel their order without giving a reason, the period in which the consumer has the right to cancel the order starts at the time the order is placed and ends 7 days after the day that the goods are received."
Currently we only mark an order as processed the day that it is being dispatched, all items go on a over night carrier, so if we knew when the item was maked as procssed we can ensur we stick to the candition as laid out.. also when parcels go missing it will enable us to provde the date they were shipped