i finally got the guts to run the code. It date stamped all the 'Date Posted' to 11/30/1999 00:00:00. Is there a way to run a statement to change the dates to the actual date of which the payment was made?
Code:insert into so_payments (orders_id, payment_amount) select orders_id, value from zen_orders_total zot where zot.sort_order=999;
Bookmarks