Date() Format

[John Berman]

Hi

Im trying to get a mm/dd/ccyy format and can nearly do this using date()
however

I for 02 Feb 2004 I get

2/2/2004 and I want 02/02/2004


Regards

John Berman
[email]john_berman@blueyonder.co.uk[/email]

[Evertjan.]

John Berman wrote on 03 mrt 2004 in microsoft.public.inetserver.asp.db:

> Im trying to get a mm/dd/ccyy format and can nearly do this using date()
> however
>
> I for 02 Feb 2004 I get
>
> 2/2/2004 and I want 02/02/2004
>

The European way:

function two(x)
if x<10 then
two = "0" & x
else
two = "" & x
end if
end function


function date2text(x) ' input m/d/yyyy output dd/mm/yyyy
a = split(x,"/")
date2text = two(a(1)) & "/" & two(a(0)) & "/" & a(2)
end function


--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

[Aaron Bertrand [MVP]]

[url]http://www.aspfaq.com/2313[/url]

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




"John Berman" <John_berman@blueyonder.co.uk> wrote in message
news:NGs1c.274$E%5.174@news-binary.blueyonder.co.uk...

> Hi
>
> Im trying to get a mm/dd/ccyy format and can nearly do this using date()
> however
>
> I for 02 Feb 2004 I get
>
> 2/2/2004 and I want 02/02/2004
>
>
> Regards
>
> John Berman
> [email]john_berman@blueyonder.co.uk[/email]
>
>