Shipdate Contribution v2.1

[stujol]

Shipdate Contribution v2.1

for OSCommerce 2.2 MS2

 

I’ve installed the contribution for the florist ship dates and all seems fine except for one major fault. I’ve played with it for hours but are unable to resolve it.

 

When you have selected a delivery date and completed the checkout process, you get an email stating the correct delivery date. When viewing customers orders via the admin panel, there is no mention of the delivery date. I’ve been doing abit of coding to display the date but when viewing the shipdate field in the orders table, the information contacted in the shipdate field is INCORRECT. A date of January 12 2009 is stored in the table as 1231714800

 

Unable to determine why data is displayed in this format instead of date format. Any ideas please?????

[stujol]

the following sql code used to modify order table

 

ALTER TABLE `orders` ADD `shipdate` VARCHAR( 10 ) NOT NULL ;