Inserting the Date

[casey5]

Can anyone help??? I am trying to create a form that uploads to the database. When you type in the info I have everthing working but I want to be able to enter the date by m/d/y? I am pulling my hair out. Please see part of the code... What am I doing wrong?? SHould it go somewhere else in the code. If so, where?

 

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "AddOrder")) {

$insertSQL = sprintf("INSERT INTO orders (UserID, OrderTitle, StationName, MarketName, StartDate, EndDate, name) VALUES (%s, %s, %s, %s, %s, %s, %s)",

GetSQLValueString($_POST['CompanyName'], "int"),

GetSQLValueString($_POST['OrderTitle'], "text"),

GetSQLValueString($_POST['StationName'], "text"),

GetSQLValueString($_POST['MarketName'], "text"),

GetSQLValueString($_POST['StartDate'], "date = %c%d%Y"),

GetSQLValueString($_POST['EndDate'], "date"),

GetSQLValueString($_FILES['filetoupload']['name'], "text"));

 

 

Thanks in advance!!