Can't change data type from text to date in Summary or Details to database
Hi,
This seems to be an issue with Ecart 5x because these forms have alwyas worked for me. Since I upgraded to 5 the OrderDate column, which is a mysql date column, shows up in the Ecart SB as a Text type and sumbits all 0'c (000-00-00) in the Order Date fileds both in the summary and details to database server behaviors. This is a real problem for me because all of my clients are now not getting order dates!
The confirmation page has always worked with a hidden field as below:
<input type="hidden" name="orderdate" id="orderdate" value="<?php echo date("Y-m-d"); ?>" />
But since upgrading the SB sees this as a text field and I can't change it back to a Date type filed. The result is breaking all of my carts because the order dates are all 0's.
So, what do I need to do to get the SB to recognize this field as a date filed? Reformatting the database to use integer fields is not, and shouldn't have to be, an option.
Thanks for any help,
Tony