<div>
format is not a valid vbscript function. &nbsp;it's best to create a customized function to accomplish this:<br />
<br />
function formatDateYMD(sDate)<br />
&nbsp; &nbsp;dim sY, sM, sD<br />
&nbsp; &nbsp;sY = Year(sDate)<br />
&nbsp; &nbsp;sM = Month(sDate)<br />
&nbsp; &nbsp;sD = Day(sDate)<br />
&nbsp; &nbsp;if Len(sM) = 1 then sM = &quot;0&quot; &amp;&nbsp;sM<br />
&nbsp; &nbsp;if Len(sD) = 1 then sM = &quot;0&quot; &amp;&nbsp;sD<br />
&nbsp; &nbsp;formatDateYMD = sY &amp;&nbsp;sM &amp;&nbsp;sD<br />
end function
</div>


format is not a valid vbscript function.  it's best to create a customized function to accomplish this:

function formatDateYMD(sDate)
   dim sY, sM, sD
   sY = Year(sDate)
   sM = Month(sDate)
   sD = Day(sDate)
   if Len(sM) = 1 then sM = "0" & sM
   if Len(sD) = 1 then sM = "0" & sD
   formatDateYMD = sY & sM & sD
end function

<div>
oops sM should be sD in this line:<br />
<br />
if Len(sD) = 1 then sD = &quot;0&quot; &amp;&nbsp;sD<br />

</div>


oops sM should be sD in this line:

if Len(sD) = 1 then sD = "0" & sD


<div>
and test it with:<br />
<br />
Response.write formatDateYMD(Date())
</div>


and test it with:

Response.write formatDateYMD(Date())

<div>
<div class="content wysiwyg-content">
Why does this:<br />
Response.Write Format(Date(),&quot;yyyymmdd&quot;)<br />
<br />
Return this:<br />
Microsoft VBScript runtime error '800a000d' <br />
<br />
Type mismatch: 'Format' <br />
<br />
<br />
My objective is to take a datetime field from SQL Server and convert that date to the following format on, YYYYMMDD.<br />
<br />
Thanks in advance...
</div>
</div>


Why does this:
Response.Write Format(Date(),"yyyymmdd")

Return this:
Microsoft VBScript runtime error '800a000d' 

Type mismatch: 'Format' 


My objective is to take a datetime field from SQL Server and convert that date to the following format on, YYYYMMDD.

Thanks in advance...

Type mismatch: 'Format'

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.