Hvordan laver jeg om til Access Dato format

Det virker tilsyneladende hvis jeg bruger en input type text?... men hvorfor virker det så ikke når jeg bruger select ?..

hvis du laver en select skal du gøre flg.

lad os sige din input ser således ud

<input type=\"text\" name=\"dato\" value=\"<%=date()%>\">

Så skal din select se sådan ud
<select name=\"date\">
<option value=\"<%=date()%>\">jae</option>
osv
</select>

Oki... det prøver jeg så

Well tak det virkede :)

Neeej det gjorde det da ikke :(

hehe :)

Hvordan ser din kode ud nu?

<%

if request.Querystring(\"mode\") = \"create\" then
Set DataConn = Server.CreateObject(\"ADODB.Connection\")
DSN = \"DRIVER={Microsoft Access Driver (*.mdb)}; \"
DSN = dsn & \"DBQ=\" & server.mappath(\"../../db/db.mdb\")
DataConn.Open DSN

Set rs = Server.CreateObject(\"ADODB.RecordSet\")
rs.open \"Select * From [t_party] Order by id\", DataConn, 1, 3 

vardate = CLng(request.form(\"day\"))
varmonth = CLng(request.form(\"month\"))
varyear = CLng(request.form(\"year\"))


count_date = varday & \"-\" & varmonth & \"-\" & varyear

\'count_date = trim(request.form(\"date\")) & \"-\" & trim(request.form(\"month\")) & \"-\" trim(request.form(\"yeah\"))


rs.addnew
rs.Fields(\"count_date\") = count_date
rs.Fields(\"fra_dag\") = request.form(\"st_day\")
rs.Fields(\"til_dag\") = request.form(\"sl_day\")
rs.Fields(\"fra_dato\") = request.form(\"st_dd\") & \" \" & request.form(\"st_mmm\")
rs.Fields(\"til_dato\") = request.form(\"sl_dd\") & \" \" & request.form(\"sl_mmm\")
rs.Fields(\"max\") = request.form(\"max\")
rs.Fields(\"info\") = request.form(\"info\")
rs.fields(\"events\") = request.form(\"event\")
rs.update
response.redirect \"?site=admin/new_party\"



End If
%>
<div align=center>
<!--webbot BOT=\"GeneratedScript\" PREVIEW=\" \" startspan --><script Language=\"JavaScript\"><!--
function FrontPage_Form1_Validator(theForm)
{

  var checkOK = \"0123456789-\";
  var checkStr = theForm.max.value;
  var allValid = true;
  var decPoints = 0;
  var allNum = \"\";
  for (i = 0;  i < checkStr.length;  i++)
  {
    ch = checkStr.charAt(i);
    for (j = 0;  j < checkOK.length;  j++)
      if (ch == checkOK.charAt(j))
        break;
    if (j == checkOK.length)
    {
      allValid = false;
      break;
    }
    allNum += ch;
  }
  if (!allValid)
  {
    alert(\"Skriv kun tal tegn i feltet \\\"max\\\".\");
    theForm.max.focus();
    return (false);
  }
  return (true);
}
//--></script><!--webbot BOT=\"GeneratedScript\" endspan --><form method=\"POST\" action=\"admin/new_party.asp?mode=create\" onsubmit=\"return FrontPage_Form1_Validator(this)\" name=\"FrontPage_Form1\">
<table border=\"0\" width=\"563\" cellspacing=\"0\" cellpadding=\"0\" style=\"border: 1 solid #000000\">
  <tr>
    <td width=\"547\" bgcolor=\"#005177\" colspan=\"3\" valign=\"top\" style=\"border-bottom: 1 solid #000000\">
      <p align=\"center\"><b><font face=\"Verdana\" size=\"2\" color=\"#FFFFFF\">Opret
      et TB Netparty</font></b></p>
    </td>
  </tr>
  <tr>
    <td width=\"128\" bgcolor=\"#006699\" valign=\"middle\">
   

<font size=\"2\" face=\"Verdana\" color=\"#FFFFFF\">Start Dato (short)</font>
   
    </td>

  <td width=\"240\" bgcolor=\"#006699\" valign=\"middle\">
   
<font face=\"Verdana\" size=\"2\" color=\"#FFFFFF\"><select size=\"1\" name=\"day\">
  <option value=\"01\">01</option>
  <option value=\"02\">02</option>
  <option value=\"03\">03</option>
  <option value=\"04\">04</option>
  <option value=\"05\">05</option>
  <option value=\"06\">06</option>
  <option value=\"07\">07</option>
  <option value=\"08\">08</option>
  <option value=\"09\">09</option>
  <option value=\"10\">10</option>
  <option value=\"11\">11</option>
  <option value=\"12\">12</option>
  <option value=\"13\">13</option>
  <option value=\"14\">14</option>
  <option value=\"15\">15</option>
  <option value=\"16\">16</option>
  <option value=\"17\">17</option>
  <option value=\"18\">18</option>
  <option value=\"19\">19</option>
  <option value=\"20\">20</option>
  <option value=\"21\">21</option>
  <option value=\"22\">22</option>
  <option value=\"23\">23</option>
  <option value=\"24\">24</option>
  <option value=\"25\">25</option>
  <option value=\"26\">26</option>
  <option value=\"27\">27</option>
  <option value=\"28\">28</option>
  <option value=\"29\">29</option>
  <option value=\"30\">30</option>
  <option value=\"31\">31</option>
</select>  - <select size=\"1\" name=\"month\">
  <option value=\"01\">01</option>
  <option value=\"02\">02</option>
  <option value=\"03\">03</option>
  <option value=\"04\">04</option>
  <option value=\"05\">05</option>
  <option value=\"06\">06</option>
  <option value=\"07\">07</option>
  <option value=\"08\">08</option>
  <option value=\"09\">09</option>
  <option value=\"10\">10</option>
  <option value=\"11\">11</option>
  <option value=\"12\">12</option>
</select>  - <select size=\"1\" name=\"year\">
  <option selected value=\"2001\">2001</option>
  <option value=\"2002\">2002</option>
  <option value=\"2003\">2003</option>
  <option value=\"2004\">2004</option>
  <option value=\"2005\">2005</option>
</select></font>

<- ca sårn her... der er lidt merere.. men det virker helt ok.. så det er kun det her jeg mangler at få klaret

Count_date er den dato jeg skal bruge.. de andre er bare nogle text baseret nogen jeg udskriver.. gad ikke lige lave noget der omskrev fra short til long date :)

vardato = request.form(\"day\") & request.form(\"month\") & request.form(\"year\")