double figure of day and month

[Andrew]

Hi,

I am going to use the date as my filename. How can I convert date()
["5/18/04"] to "20040518"? Thanks a thousand.

 

[Aaron Bertrand [MVP]]

<%
filename = year(date) & _
right("00" & month(date), 2) & _
right("00" & day(date), 2)

response.write filename
%>

 

[Andrew]

Thank you very much.

--
Andrew

<%
filename = year(date) & _
right("00" & month(date), 2) & _
right("00" & day(date), 2)

response.write filename
%>

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

Hi,

I am going to use the date as my filename. How can I convert date()
["5/18/04"] to "20040518"? Thanks a thousand.