[SOLVED] (SOLVED) Microsoft Access date error !!!!!!!!!

[austine_power007]

I use some code it like:

[code]<input type=\"text\" name=\"act_dat\" value=\"{$actual[0]}$actual[1]\" size='01'><span class='style12'>dd</span><input type=\"text\" name=\"act_mon\" value=\"{$actual[3]}$actual[4]\" size='01'><span class='style12'>mm</span><input type=\"text\" name=\"act_yr\" value=\"{$actual[6]}$actual[7]$actual[8]$actual[9]\" size='01'><span class='style12'>yy</span>[/code]


it return me date in three text field like: 20 12 2006

then i took three field and make it a varibale

[code]$act_date=$_POST['act_dat'];
  $act_month=$_POST['act_mon'];
  $act_year=$_POST['act_yr'];
  $actual=$act_month.'/'.$act_date.'/'.$act_year;[/code]

then i update the database

[code]$query = odbc_exec($odbc, "UPDATE task SET actual_end_date = $actual,complete = $complete, remark = '$remark'  WHERE title = '$title'") or die ("Wrong data");[/code]

after update, it shows me some error: :'(

[code]Windows does not support dates prior to midnight (00:00:00), January 1, 1970 [/code]

Can any one help me out??

[austine_power007]

Yesss i solved the problem it is only for the ' ' around the $actual in Update field