<div>
You can use CDate() to convert the values to Date/Time before inserting them. &nbsp;An example could be:<br />

<pre><code id="code-306468">if IsDate(resdate) then
  resdate = CDate(resdate)
else
  document.write(&quot;Not a date/time!&quot;)
end if 
if IsDate(restime) then
  restime= CDate(restime)
else
  document.write(&quot;Not a date/time!&quot;)
end if 
'Now you can insert into your database
</code></pre>
</div>


You can use CDate() to convert the values to Date/Time before inserting them.  An example could be:


if IsDate(resdate) then
  resdate = CDate(resdate)
else
  document.write("Not a date/time!")
end if 
if IsDate(restime) then
  restime= CDate(restime)
else
  document.write("Not a date/time!")
end if 
'Now you can insert into your database


<div>
<div class="content wysiwyg-content">
I have two strings that need to be converted before inserted into an access database. The fields that they are to be inserted are date/time.<br />
How do I convert so that they will insert in date time format.<br />

<pre><code id="code-306450">resdate = &quot;somedate&quot;
restime = &quot;sometime&quot; 
insert into table (flddate, fldtime) values (resdate, restime)
</code></pre>
</div>
</div>


I have two strings that need to be converted before inserted into an access database. The fields that they are to be inserted are date/time.
How do I convert so that they will insert in date time format.

ASP Format Date

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.