But the Drupal dates are an int field. You'll need to convert the integer time into the Datetime format and vice versa. See http://us.php.net/time for information on what Drupal stores.
Hi Earnie The Date module creates the fields as "datetime"..
From phpMyAdmin
`field_booking_actual_value` datetime DEFAULT NULL, `field_booking_actual_value2` datetime DEFAULT NULL,
Today I have been looking at the node_save and drupal_execute options for creating nodes programatically.. It doesn't look too difficult (famous last words) so may be a solution to working with the drupal data and creating or updating nodes from our clocking interface..
The MSAccess issue is resolved now by using a feed to import the bookings from a CSV..