<div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im"><br>
</div>But the Drupal dates are an int field. You'll need to convert the<br>
integer time into the Datetime format and vice versa. See<br>
<a href="http://us.php.net/time" target="_blank">http://us.php.net/time</a> for information on what Drupal stores.<br>
<div class="HOEnZb"><div class="h5"></div></div></blockquote><div><br></div><div>Hi Earnie</div><div>The Date module creates the fields as "datetime"..</div><div><br></div><div>From phpMyAdmin</div><div><div>`field_booking_actual_value` datetime DEFAULT NULL,</div>
<div>`field_booking_actual_value2` datetime DEFAULT NULL,</div></div><div><br></div><div>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..</div>
<div><br></div><div>The MSAccess issue is resolved now by using a feed to import the bookings from a CSV..</div><div><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="HOEnZb"><div class="h5"><br></div></div></blockquote></div>