I've tried "now()" in my sql statement... i've tried a formatted date... (both statements work in mySQL just fine, but not here...) What am I missing?
function BeforeAdd(&$values)
{
// Parameters:
// $values - Array object.
// Each field on the Add form represented as 'Field name'-'Field value' pair
//** Save new data in another table ****
global $conn,$strTableName;
$archDate = date("Y-m-d H:i:s");
$strSQLUpdate = "update Items set Archive_Date = ";
$strSQLUpdate .= "'".$archDate."'";
$strSQLUpdate .= " where LogIndex =";
$strSQLUpdate .= $values["LogIndex"];
db_exec($strSQLUpdate,$conn);
}