I'm having trouble getting a date into access that has been "recorded" at the time a user fills out a form, below is my javascript, and then below that is a hidden field that holds the javascript variable.. and then an asp page that collects the date..

<SCRIPT LANGUAGE="JavaScript">
var month = new Array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec");
var nowDate = new Date();
 nowDate = nowDate.getDate() + " " + month[nowDate.getMonth()] + " " + nowDate.getFullYear();
var nowDatevar = document.write (nowDate);
</script>


Below is my form input that I thought would work to pass the date to access:

<input type=hidden name="datePosted" value= <% nowDatevar %> >


then on my asp page I have the below script to add the date to the access database..:
strInsert = strInsert & ",datePosted"
    strValues = strValues & ",'" & _
            Cstr(Request.Form("datePosted")) & "'"

any help would be great!
thanks

You don't need the hidden field to hold the date value. Just place it directly into the database with an insert statement on your .asp page like:

<%@ LANGUAGE = JavaScript%>
<%
   var month = new Array("Jan","Feb","Mar","Apr","May","Jun","Jul",
      "Aug","Sep","Oct","Nov","Dec");
   var nowDate = new Date();
   var nowDate = nowDate.getDate() + " " + month[nowDate.getMonth()] + " " +
      nowDate.getFullYear();
   var orderNo;

   // Connect to database
   var adoConnection = Server.CreateObject("ADODB.Connection");
   adoConnection.Open("DSN=MySystemDSN");
   var adoRecordset;

   // Create SQL to insert new order with date value
   var mySQL = "INSERT INTO CustomerOrder " +
      "(CustomerName, CustomerAddress, TelNumber, OrderDate)";
   mySQL = mySQL + " VALUES ('" + Request.Form("txtCustomerName") + "','";
   mySQL = mySQL + Request.Form("txtCustomerAddress") + "','";
   mySQL = mySQL + Request.Form("txtTelNumber") + "','";
   mySQL = mySQL + nowDate + "')";

   // Execute SQL to add new order
   adoConnection.Execute(mySQL);

   // Create SQL to get autonumber generated OrderNo from CustomerOrder table
   // for order just added
   mySQL = "SELECT Max(OrderNo) AS MaxOrderNo FROM CustomerOrder WHERE ";
   mySQL = mySQL + " OrderDate = #" + nowDate + "# AND ";
   mySQL = mySQL + " CustomerName = '" + Request.Form("txtCustomerName") + "'";

   // Populate recordset with SQL to get OrderNo
   adoRecordset = adoConnection.Execute(mySQL);

   orderNo = adoRecordset("MaxOrderNo").Value;

   // Recordset not needed after this so close it and allow release of memory
   adoRecordset.Close();
   adoRecordset = null;

 HTH,

Bob