Bizarre Day() feature

jethro_uk · Jul 13, 2006

Hi all,

I'm having a hard time with the Day() function. Basically, it appears
to be picking and choosing which part of a date string it uses to
return the result ...

heres some code :

<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>
</HEAD>
<BODY>
<%
Function formatDate(dDate)

formatDate=""
If IsNull(dDate) or Trim(dDate)="" Then
Else If IsDate(dDate) Then
If dDate<CDate("January 1, 1901") Then
formatDate=" - - "
Else formatDate=Day(dDate) & " " & MonthName(Month(dDate), true) &
" " & year(dDate)
End If
End If
End If
If formatDate="1 Jan 1900" Then
formatDate="n/a"
End If
End Function

dim sDate1,sDate2

sDate1="12-31-06"
sDate2="07/11/2006"
sDate2="26-12-2006"

Response.Write ("DEFAULT Session.LCID=" & Session.LCID)
Response.Write (" ")
Response.Write ("Date1=" & sdate1 & ". formatDate(" & sdate1 & ") ='" &
formatDate(sdate1) & "'")
Response.Write (" ")
Response.Write ("Date2=" & sdate2 & ". formatDate(" & sdate2 & ") ='" &
formatDate(sdate2) & "'")
session.LCID=1033
Response.Write (" ")
Response.Write (" ")
Response.Write ("Session.LCID=" & Session.LCID)
Response.Write (" ")
Response.Write ("Date1=" & sdate1 & ". formatDate(" & sdate1 & ") ='" &
formatDate(sdate1) & "'")
Response.Write (" ")
Response.Write ("Date2=" & sdate2 & ". formatDate(" & sdate2 & ") ='" &
formatDate(sdate2) & "'")
session.LCID=2057
Response.Write (" ")
Response.Write (" ")
Response.Write ("Session.LCID=" & Session.LCID)
Response.Write (" ")
Response.Write ("Date1=" & sdate1 & ". formatDate(" & sdate1 & ") ='" &
formatDate(sdate1) & "'")
Response.Write (" ")
Response.Write ("Date2=" & sdate2 & ". formatDate(" & sdate2 & ") ='" &
formatDate(sdate2) & "'")
%>
 

</BODY>
</HTML>

OUTPUT################################
DEFAULT Session.LCID=2057
Date1=12-31-06. formatDate(12-31-06) ='31 Dec 2006'
Date2=26-12-2006. formatDate(26-12-2006) ='26 Dec 2006'

Session.LCID=1033
Date1=12-31-06. formatDate(12-31-06) ='31 Dec 2006'
Date2=26-12-2006. formatDate(26-12-2006) ='26 Dec 2006'

Session.LCID=2057
Date1=12-31-06. formatDate(12-31-06) ='31 Dec 2006'
Date2=26-12-2006. formatDate(26-12-2006) ='26 Dec 2006'
/OUTPUT###################################

Notice how it uses the FIRST part of sDate1 to return the day, but the
SECOND part of sDate2

I have tried fiddling with the Locale settings, but whatever they are,
Day("12/26/2006") always returns "26".

Can anyone explain, and hopefully suggest what to do ?

Thanks in advance

Patrice · Jul 13, 2006

This is expected 12/26/2006 is always thought to be day 26 of month 12
because it can't be day 12 of month 26...

Note that the problem doesn't lie really with the Day function itself. The
problem is that Day should use a date parameter not a string. As you are
providing a string to this function, the string is first converted to a date
(and it can't be anything else than day 26 month 12). The day is just then
extracted from the date. As a result it always return 26.

Try rather with a date such as 02/03 that can be day 2 of month 3 or day 3
of month 2.

Also my personal preference is to work always with the proper datatype i.e.
to convert a user input string as soon as possible to a real date variable
(or to use a real date variable from the beginning if this is not a user
input)...

Bob Barrows [MVP] · Jul 13, 2006

Hi all,

I'm having a hard time with the Day() function. Basically, it appears
to be picking and choosing which part of a date string it uses to
return the result ...

To add to what Patrice said: always use a standard date format such as
the ISO standard YYYY-MM-DD

You can use UI gadgets such as calendar controls or dropdown controls to
enforce the standard format.

Egbert Nierop \(MVP for IIS\) · Jul 14, 2006

Hi all,

I'm having a hard time with the Day() function. Basically, it appears
to be picking and choosing which part of a date string it uses to
return the result ...

heres some code :

Enclose a Date 'string' with #

like this

a = CDate(#31/12/2006#)

This is a rarity in VBS, not known by many scripters.

Of course, in my case, the date format (dd-mm-yyyy) between # # is
according to my own locale.

A number everyday of the month "and" a different number depending on the day of the month´s day time	2	Mar 16, 2021
Serious help needed - Calendar!	7	Jul 28, 2008
Help with my responsive home page	2	Dec 14, 2022
Working on mobile css menu with plenty of frustration!	2	Dec 29, 2022
Adding dates to an XML Node	0	Jan 18, 2006
Connected SQLite to my java program but information are not submitted	2	Aug 2, 2022
ASP - DNS - Run Time Error	2	Nov 9, 2006
how to get next day	5	Mar 20, 2007

Bizarre Day() feature

jethro_uk

Patrice

Bob Barrows [MVP]

Egbert Nierop \(MVP for IIS\)

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads