Year Date Format

[Silvinho]

Is it possible to display only the year of a date in asp

ie: the database stores the record '21/08/2002', i just want the asp page to show '2002'

 

[mit99mh]

try this:

<%
Dim iYear
iYear = DatePart(&quot;yyyy&quot;, objRS(&quot;myDate&quot)
Response.write iYear

%>

Hope it helps

 

[robctech]

Try this,

<%=year(recordset(&quot;datefield&quot;))%>

if you need something else or are getting errors give more detail and copy of the error.

Hope this helps

 

[onpnt]

faq329-2091 A language that doesn't affect the way you think about programming is not worth knowing.

http://www.onpntwebdesigns.com

admin@onpntwebdesigns.com