date value of text field (set by using javascript popup calendar) does not appear when editing node

Hi,

Please note ...I am learning to program in Drupal/PHP....and have tried getting help from posts in the forum....not much luck...

I am exploring the use of the javascript popup calendar (jscalendar) in a custom node module. I am creating a very basic module to test this. Also, I've used the readme file provided by the author of jscalendar for help.

the main functions of the module is listed below.

here's a brief description

I am able to use the pop calendar attached to the field, fromdate to select a date. It is entered in the table, exam as : 2007-07-17 13:28:06.

fieldtype of fromdate in table exam is varchar2(20).

When I view the node, I see the value of fromdate.

When I go to edit the node, the text field fromdate in the form is blank. If I use this popup calendar in a CCK nodetype, the value does appear in the textfield when the node is viewed in edit mode.

I would like the value to appear in the textfield ,fromdate when the node (that is, from my custom module)is viewed in edit mode.

I suspect it is my exam_load that may be the problem....or do I have to use exam_prepare function to set the date display format. I've tried this..not getting it to work...I'm not understanding this properly.

Any ideas on what I am doing incorrectly or not doing at all....or need to do ?

I would appreciate any help please..thanks alot. Here's the code Ive been working with..

function exam_form(&$node) {
 
$form['exam_title'] = array(
    '#type' => 'textfield',
    '#title' => t('Name'),
    '#required' => TRUE,
    '#default_value' => $node->exam_title,
    '#weight' => -5,
    '#description' => t('Name')
  );

$form['examdate'] = array(
    '#type' => 'textfield',
    '#attributes' => array('class' => 'jscalendar'),
    // Use only year, month, and day in textfield.
    '#jscalendar_ifFormat' => '%Y-%m-%d %H:%M:%S',
    // Don't show time.
    '#jscalendar_showsTime' => 'true',
    // Show 24-hour clock.
    '#jscalendar_timeFormat' => '12',
  ); 

 return $form;
}

function exam_insert($node) {

 db_query("INSERT INTO {exam} (nid, exam_title, examdate) VALUES (%d, '%s', '%s')", $node->nid, $node->exam_title, $node->examdate);

}

function exam_prepare(&$node) {
	//not sure about this...think its wrong
    $node->examdate = date('Y-m-d H:M:S', $node->examdate);
}

function exam_load($node) {
   
	$t1 = db_fetch_object(db_query('SELECT exam_title, examdate FROM {exam} WHERE nid = %d', $node->nid));
	return $t1; 
}

function exam_update($node) {

  db_query("UPDATE {exam} set exam_title='%s', examdate='%s' WHERE nid=%d", $node->exam_title, $node->examdate, $node->nid);
}

function exam_delete(&$node) {
  db_query('DELETE FROM  {exam} WHERE nid = %d', $node->nid);
}