Re: double figure of day and month

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 05/19/04 

Date: Tue, 18 May 2004 20:19:48 -0400

<%
    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/
"Andrew" <dunggaze@yahoo.com> wrote in message 
news:iExqc.65536$0qd.52815@twister01.bloor.is.net.cable.rogers.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.
>
> -- 
> Andrew
>
>
>
>

Relevant Pages

  • Re: database maintenance for companies that run 24/7
    ... fixes, windows update, etc. ... Aaron Bertrand ... SQL Server MVP ... "Andrew J. Kelly" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: Name of file that contains proc
    ... Andrew wrote: ... #>> I'm wondering how to get the filename of the file that contains the ... # command with your own version," but being a newbie I have no idea what ...
    (comp.lang.tcl)
  • Re: How do I copy a file using xp_cmdshell
    ... I switched to a different account and now it works fine. ... > command) have access to this share? ... > Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: C-Shell: How to append to filename?
    ... Andrew wrote: ... know how to rename each file in a directory by appending a _new to it. ... foreach filename ...
    (comp.unix.shell)
  • Re: Unique Name Generation
    ... Actually the filename will probably only be unique to the path 8-( ... Andrew J. Marshall ... MCP ...
    (microsoft.public.dotnet.languages.vb)