Different results if you have String or a Varient for Dates?

Thomas Scheiderich

I have the following page as test.aspx:
************************************************** *
<html>
<head>
<title>Hello and Welcome Page</title>
</head>
<body>
<center>
<%
Dim CurrentDate As String
CurrentDate = Today
%>
The current date is <%=CurrentDate %>. 
</center>
</body>
</html>
************************************************** *

If I have CurrentDate as String, like I do here, I get the following
page displayed:

The current date is 2/14/2004.

But if I take out the As String and have only "Dim CurrentDate", I get
the following result:

The current date is 2/14/2004 12:00:00 AM.

Why do I get the time for the Variant and not for the string?

Tom.

Jul 19 '05 #1

Subscribe Post Reply

1640

Steven Burn

Dim strDate
Dim valTime
Dim lBoth

strDate = Date()
valTime = Time()
lBoth = Now()

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Disclaimer:
I know I'm probably wrong, I just like taking part ;o)
Thomas Scheiderich <tf*@deltanet.com> wrote in message
news:40**************@deltanet.com...

I have the following page as test.aspx:
************************************************** *
<html>
<head>
<title>Hello and Welcome Page</title>
</head>
<body>
<center>
<%
Dim CurrentDate As String
CurrentDate = Today
%>
The current date is <%=CurrentDate %>. 
</center>
</body>
</html>
************************************************** *

If I have CurrentDate as String, like I do here, I get the following
page displayed:

The current date is 2/14/2004.

But if I take out the As String and have only "Dim CurrentDate", I get
the following result:

The current date is 2/14/2004 12:00:00 AM.

Why do I get the time for the Variant and not for the string?

Tom.

Jul 19 '05 #2

Thomas Scheiderich

Steven Burn wrote:

Dim strDate
Dim valTime
Dim lBoth

strDate = Date()
valTime = Time()
lBoth = Now()
I understand the difference between these functions (which don't work in
asp.net, apparently). My problem is that I am using the same function
and get different results, depending whether the resulting variable is a
String or Variant.

Tom

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Disclaimer:
I know I'm probably wrong, I just like taking part ;o)
Thomas Scheiderich <tf*@deltanet.com> wrote in message
news:40**************@deltanet.com...
I have the following page as test.aspx:
************************************************ ***
<html>
<head>
<title>Hello and Welcome Page</title>
</head>
<body>
<center>
<%
Dim CurrentDate As String
CurrentDate = Today
%>
The current date is <%=CurrentDate %>. 
</center>
</body>
</html>
************************************************ ***

If I have CurrentDate as String, like I do here, I get the following
page displayed:

The current date is 2/14/2004.

But if I take out the As String and have only "Dim CurrentDate", I get
the following result:

The current date is 2/14/2004 12:00:00 AM.

Why do I get the time for the Variant and not for the string?

Tom.

Jul 19 '05 #3

Bob Barrows

Thomas Scheiderich wrote:

I have the following page as test.aspx:
************************************************** *
<html>
<head>
<title>Hello and Welcome Page</title>
</head>
<body>
<center>
<%
Dim CurrentDate As String
CurrentDate = Today
%>
The current date is <%=CurrentDate %>. 
</center>
</body>
</html>
************************************************** *

If I have CurrentDate as String, like I do here, I get the following
page displayed:

The current date is 2/14/2004.

But if I take out the As String and have only "Dim CurrentDate", I get
the following result:

The current date is 2/14/2004 12:00:00 AM.

Why do I get the time for the Variant and not for the string?

Tom.

The Date datatype contains time as well as the date, just like in Access and
SQL Server. Dates are numbers with subType Double. the whole number
represents the number of days since the seed date, and the decimal portion
represents the time of day (.0 = midnight, .5 = noon). If you provide a date
without providing the time (which I guess is what the Today function is
doing), the date is stored as nnnnn.0. So when that date is written, the
"12:00 AM" is included.

Bob Barrows

PS. This is a classic asp newsgroup. .Net questions should be asked in the
appropriate "dotnet" newsgroup. There are several in that hierarchy.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #4

Thomas Scheiderich

Bob Barrows wrote:

Thomas Scheiderich wrote:
I have the following page as test.aspx:
************************************************ ***
<html>
<head>
<title>Hello and Welcome Page</title>
</head>
<body>
<center>
<%
Dim CurrentDate As String
CurrentDate = Today
%>
The current date is <%=CurrentDate %>. 
</center>
</body>
</html>
************************************************ ***

If I have CurrentDate as String, like I do here, I get the following
page displayed:

The current date is 2/14/2004.

But if I take out the As String and have only "Dim CurrentDate", I get
the following result:

The current date is 2/14/2004 12:00:00 AM.

Why do I get the time for the Variant and not for the string?

Tom.
The Date datatype contains time as well as the date, just like in Access and
SQL Server. Dates are numbers with subType Double. the whole number
represents the number of days since the seed date, and the decimal portion
represents the time of day (.0 = midnight, .5 = noon). If you provide a date
without providing the time (which I guess is what the Today function is
doing), the date is stored as nnnnn.0. So when that date is written, the
"12:00 AM" is included.

I understand that and have no trouble with that.

What I am confused on is why we get different results, depending whether
the resulting variable is a String or Variant. I am assuming that the
time is being truncated for the String and not for the Variant. Why?

Bob Barrows

PS. This is a classic asp newsgroup. .Net questions should be asked in the
appropriate "dotnet" newsgroup. There are several in that hierarchy.

Jul 19 '05 #5

Bob Barrows

Thomas Scheiderich wrote:

Bob Barrows wrote:
Thomas Scheiderich wrote:
I have the following page as test.aspx:
************************************************** *
<html>
<head>
<title>Hello and Welcome Page</title>
</head>
<body>
<center>
<%
Dim CurrentDate As String
CurrentDate = Today
%>
The current date is <%=CurrentDate %>. 
</center>
</body>
</html>
************************************************** *

If I have CurrentDate as String, like I do here, I get the following
page displayed:

The current date is 2/14/2004.

But if I take out the As String and have only "Dim CurrentDate", I
get
the following result:

The current date is 2/14/2004 12:00:00 AM.

Why do I get the time for the Variant and not for the string?

Tom.

The Date datatype contains time as well as the date, just like in
Access and SQL Server. Dates are numbers with subType Double. the
whole number represents the number of days since the seed date, and
the decimal portion represents the time of day (.0 = midnight, .5 =
noon). If you provide a date without providing the time (which I
guess is what the Today function is doing), the date is stored as
nnnnn.0. So when that date is written, the "12:00 AM" is included.

I understand that and have no trouble with that.

What I am confused on is why we get different results, depending
whether
the resulting variable is a String or Variant. I am assuming that the
time is being truncated for the String and not for the Variant. Why?

I have not started using .Net yet so I can't answer that question. If the
answer isn't in the documentation, then you should ask over at
..dotnet.framework.vbnet (I think that's what the group's name is ... )

My guess is that Today returns a string containing only the date, so when
assigned to a string variable, it only contains the date. When the value
returned from Today is converted to Date, the 12 AM is implied by the lack
of a time specification. Again: look it up in the documentation, or ask on
the vbnet group.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #6

Vilmar Brazão de Oliveira

hi, try to use formatdatetime function, the help follows:
FormatDateTime Function Language Reference
Version 2

See Also

Description
Returns an expression formatted as a date or time.
Syntax
FormatDateTime(Date[, NamedFormat])
The FormatDateTime function syntax has these parts:
PartDescription
DateRequired. Date expression to be formatted.
NamedFormatOptional. Numeric value that indicates the date/time format used.
If omitted, vbGeneralDate is used.

Settings
The NamedFormat argument has the following settings:
ConstantValueDescription
vbGeneralDate0Display a date and/or time. If there is a date part, display
it as a short date. If there is a time part, display it as a long time. If
present, both parts are displayed.
vbLongDate1Display a date using the long date format specified in your
computer's regional settings.
vbShortDate2Display a date using the short date format specified in your
computer's regional settings.
vbLongTime3Display a time using the time format specified in your computer's
regional settings.
vbShortTime4Display a time using the 24-hour format (hh:mm).

Remarks
The following example uses the FormatDateTime function to format the
expression as a long date and assign it to MyDateTime:
Function GetCurrentDate
' FormatDateTime formats Date in long date.
GetCurrentDate = FormatDateTime(Date, 1)
End Function

bye,
--
««««««««»»»»»»»»»»»»»»
Vlmar Brazão de Oliveira
Desenvolvimento Web
HI-TEC
"Thomas Scheiderich" <tf*@deltanet.com> escreveu na mensagem
news:40**************@deltanet.com...

I have the following page as test.aspx:
************************************************** *
<html>
<head>
<title>Hello and Welcome Page</title>
</head>
<body>
<center>
<%
Dim CurrentDate As String
CurrentDate = Today
%>
The current date is <%=CurrentDate %>. 
</center>
</body>
</html>
************************************************** *

If I have CurrentDate as String, like I do here, I get the following
page displayed:

The current date is 2/14/2004.

But if I take out the As String and have only "Dim CurrentDate", I get
the following result:

The current date is 2/14/2004 12:00:00 AM.

Why do I get the time for the Variant and not for the string?

Tom.

Jul 19 '05 #7

by: Stephen Poley | last post by:

I have quite often (as have probably many of you) come across HTML forms with irritating bits of Javascript attached. The last straw on this particular camel's back was a large form I was asked to...

Javascript

"Split & Parts" different results in Firefox & IExplorer

by: kinne | last post by:

The following code is supposed to reverse the date in "yyyy-mm-dd" format, but it produces different results in Firefox 1.0 and in Internet Explorer 6SP1. In Firefox, the result is correct...

Javascript

Queries using different date ranges

by: Steve Elliott | last post by:

I have a query set up to gather together data between two specified dates. Shown in the query column as: Between #24/09/2004# And #01/10/2004# Is it possible to enter several different date...