Date format

[Paulo]

Any function on ASP to format date on dd/mm/yyyy?
The format (VB) function does not work on ASP ?

Thanks!

[McKirahan]

"Paulo" <pr*****@uol.com.brwrote in message
news:Om**************@TK2MSFTNGP02.phx.gbl...

Any function on ASP to format date on dd/mm/yyyy?
The format (VB) function does not work on ASP ?

FormatDateTime() may meet your needs.

VBScript FormatDateTime Function
http://www.w3schools.com/vbscript/fu...atdatetime.asp

FormatDateTime(Now,2) = 02/15/2008 (mm/dd/yyyy) for me.

If you need dd/mm/yyyy then you may have to construct it
using DatePart(); for example, (where "x" is your date):

DatePart("d",x) & "/" & DatePart("m",x) & "/" & DatePart("yyyy",x)

Be aware that the day and month returned are not left-zero filled;
that is, today's date will appear as 15/2/2008 unless adjusted.

[Paulo]

Any way to optimize it ?

<% sDia = ""
sMes = ""
sAno = ""
sData = ""
if not IsNull(rs("DT_EXAME")) then
sDia = Day(rs("DT_EXAME"))
sMes = Month(rs("DT_EXAME"))
sAno = Year(rs("DT_EXAME"))
if Len(sDia) = 1 then sDia = "0" & sDia
if Len(sMes) = 1 then sMes = "0" & sMes
sData = sDia & "/" & sMes & "/" & sAno
end if
%>

returns the dd/mm/yyyy coming from a db date field with left-zero filled

"McKirahan" <Ne**@McKirahan.comescreveu na mensagem
news:TK******************************@comcast.com. ..

"Paulo" <pr*****@uol.com.brwrote in message
news:Om**************@TK2MSFTNGP02.phx.gbl...

>Any function on ASP to format date on dd/mm/yyyy?
The format (VB) function does not work on ASP ?

FormatDateTime() may meet your needs.

VBScript FormatDateTime Function
http://www.w3schools.com/vbscript/fu...atdatetime.asp

FormatDateTime(Now,2) = 02/15/2008 (mm/dd/yyyy) for me.

If you need dd/mm/yyyy then you may have to construct it
using DatePart(); for example, (where "x" is your date):

DatePart("d",x) & "/" & DatePart("m",x) & "/" & DatePart("yyyy",x)

Be aware that the day and month returned are not left-zero filled;
that is, today's date will appear as 15/2/2008 unless adjusted.

[Jon Paal [MSMD]]

http://dypso.free.fr/tech/asp_format_date_time-en.php

"Paulo" <pr*****@uol.com.brwrote in message news:ez****************@TK2MSFTNGP05.phx.gbl...

Any way to optimize it ?

<% sDia = ""
sMes = ""
sAno = ""
sData = ""
if not IsNull(rs("DT_EXAME")) then
sDia = Day(rs("DT_EXAME"))
sMes = Month(rs("DT_EXAME"))
sAno = Year(rs("DT_EXAME"))
if Len(sDia) = 1 then sDia = "0" & sDia
if Len(sMes) = 1 then sMes = "0" & sMes
sData = sDia & "/" & sMes & "/" & sAno
end if
%>

returns the dd/mm/yyyy coming from a db date field with left-zero filled

"McKirahan" <Ne**@McKirahan.comescreveu na mensagem news:TK******************************@comcast.com. ..

>"Paulo" <pr*****@uol.com.brwrote in message
news:Om**************@TK2MSFTNGP02.phx.gbl...

>>Any function on ASP to format date on dd/mm/yyyy?
The format (VB) function does not work on ASP ?

FormatDateTime() may meet your needs.

VBScript FormatDateTime Function
http://www.w3schools.com/vbscript/fu...atdatetime.asp

FormatDateTime(Now,2) = 02/15/2008 (mm/dd/yyyy) for me.

If you need dd/mm/yyyy then you may have to construct it
using DatePart(); for example, (where "x" is your date):

DatePart("d",x) & "/" & DatePart("m",x) & "/" & DatePart("yyyy",x)

Be aware that the day and month returned are not left-zero filled;
that is, today's date will appear as 15/2/2008 unless adjusted.

[McKirahan]

"Paulo" <pr*****@uol.com.brwrote in message
news:ez**************@TK2MSFTNGP05.phx.gbl...

Any way to optimize it ?

<% sDia = ""
sMes = ""
sAno = ""
sData = ""
if not IsNull(rs("DT_EXAME")) then
sDia = Day(rs("DT_EXAME"))
sMes = Month(rs("DT_EXAME"))
sAno = Year(rs("DT_EXAME"))
if Len(sDia) = 1 then sDia = "0" & sDia
if Len(sMes) = 1 then sMes = "0" & sMes
sData = sDia & "/" & sMes & "/" & sAno
end if
%>

returns the dd/mm/yyyy coming from a db date field with left-zero filled

[snip]

Please don't top post as it makes the conversation harder to follow.

Try this untested code:

<%
Response.Write rs("DT_EXAME") & " = " & MDY(rs("DT_EXAME"))

Function MDY(DT)
MDY = ""
If IsDate(DT) Then
MDY = Right(100+Day(DT),2) & "/" _
& Right(100+Month(DT),2) & "/" & Year(DT)
End If
End Function
%>

[McKirahan]

"Jon Paal [MSMD]" <Jon nospam Paal @ everywhere dot comwrote in message
news:13*************@corp.supernews.com...

http://dypso.free.fr/tech/asp_format_date_time-en.php

[snip]

Interesting idea; however, the following

<%
Response.Write "<li>" & FormatDateTime(Now,2)
Session.lcid=2057 '= UK English
Response.Write "<li>" & FormatDateTime(Now,2)
Session.lcid=1033 '= US English
Response.Write "<li>" & FormatDateTime(Now,2)
%>

returned (for me):

2/15/2008
15/02/08
2/15/2008

[Bob Barrows [MVP]]

Paulo wrote:

Any function on ASP to format date on dd/mm/yyyy?
The format (VB) function does not work on ASP ?

http://www.aspfaq.com/show.asp?id=2313 vbscript
http://www.aspfaq.com/show.asp?id=2040 help with dates
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Jon Paal [MSMD]]

http://www.w3schools.com/asp/prop_lcid.asp

"McKirahan" <Ne**@McKirahan.comwrote in message news:od******************************@comcast.com. ..

"Jon Paal [MSMD]" <Jon nospam Paal @ everywhere dot comwrote in message
news:13*************@corp.supernews.com...

>http://dypso.free.fr/tech/asp_format_date_time-en.php

[snip]

Interesting idea; however, the following

<%
Response.Write "<li>" & FormatDateTime(Now,2)
Session.lcid=2057 '= UK English
Response.Write "<li>" & FormatDateTime(Now,2)
Session.lcid=1033 '= US English
Response.Write "<li>" & FormatDateTime(Now,2)
%>

returned (for me):

2/15/2008
15/02/08
2/15/2008

[Evertjan.]

McKirahan wrote on 15 feb 2008 in microsoft.public.inetserver.asp.general:

<%
Response.Write rs("DT_EXAME") & " = " & MDY(rs("DT_EXAME"))

Function MDY(DT)
MDY = ""
If IsDate(DT) Then
MDY = Right(100+Day(DT),2) & "/" _
& Right(100+Month(DT),2) & "/" & Year(DT)
End If
End Function
%>

<%

response.write dateToString(#2008-02-15#, "dd/mm/yyyy") & "<br>"
response.write dateToString(#2008-02-16#, "m/d/yyyy")

function dateToString(d, frmt)
aF = split(frmt,"/")
for i=0 to 2
if aF(i) = "d" then aF(i) = day(d)
if aF(i) = "dd" then aF(i) = right("0"&day(d),2)
if aF(i) = "m" then aF(i) = month(d)
if aF(i) = "mm" then aF(i) = right("0"&month(d),2)
if aF(i) = "yyyy" then aF(i) = year(d)
next
dateToString= join(aF,"/")
end function

%>

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

[Jon Paal [MSMD]]

also see this:

http://www.4guysfromrolla.com/webtech/041001-1.shtml

"Jon Paal [MSMD]" <Jon nospam Paal @ everywhere dot comwrote in message news:13*************@corp.supernews.com...

http://www.w3schools.com/asp/prop_lcid.asp

"McKirahan" <Ne**@McKirahan.comwrote in message news:od******************************@comcast.com. ..

>"Jon Paal [MSMD]" <Jon nospam Paal @ everywhere dot comwrote in message
news:13*************@corp.supernews.com...

>>http://dypso.free.fr/tech/asp_format_date_time-en.php

[snip]

Interesting idea; however, the following

<%
Response.Write "<li>" & FormatDateTime(Now,2)
Session.lcid=2057 '= UK English
Response.Write "<li>" & FormatDateTime(Now,2)
Session.lcid=1033 '= US English
Response.Write "<li>" & FormatDateTime(Now,2)
%>

returned (for me):

2/15/2008
15/02/08
2/15/2008