Display date as mm/dd/yyyy

[Robin]

I have a variable that is set to:
vD1 = 2004/1/1
vD2 = 2004/1/15

I am doing an if/then that looks to see if date() is > vD2. If so then
response.write vD1 & " to " & vD2
When I write out the variables, it is giving me the numeric value of these
dates:
334 to 105.473684210526

How can I convert these values to either yyyy/mm/dd or dd/mm/yy??????

[Rob Meade]

"Robin" wrote ...

I have a variable that is set to:
vD1 = 2004/1/1
vD2 = 2004/1/15
With ASP or are you picking these up from a database?

If you are using 'exactly' the above you'd actually be doing a mathematical
equasion :

2004 divided by 1 divided by 1 etc
How can I convert these values to either yyyy/mm/dd or dd/mm/yy??????

Please advise as to the above.

Regards

Rob

[Peter Foti]

"Robin" <rl*****@energymasterllc.com> wrote in message
news:QO******************@bignews1.bellsouth.net.. .

I have a variable that is set to:
vD1 = 2004/1/1
vD2 = 2004/1/15

I am doing an if/then that looks to see if date() is > vD2. If so then
response.write vD1 & " to " & vD2

Look into using the DateDiff function:
http://www.devguru.com/Technologies/.../datediff.html

Also, look into using the FormatDateTime Function:
http://www.devguru.com/Technologies/...tdatetime.html

For more on dates...
http://www.aspfaq.com/show.asp?id=2313

Regards,
Peter Foti

[Robin]

I guess I just really need to learn more about date's in sql/asp.
I tried setting the variables to "01/01/2004" and to "2004/01/01", but those
are read as text strings and can't really be used to compare to a date.
I'll read up more. Thanks!

"Robin" <rl*****@energymasterllc.com> wrote in message
news:QO******************@bignews1.bellsouth.net.. .

I have a variable that is set to:
vD1 = 2004/1/1
vD2 = 2004/1/15

I am doing an if/then that looks to see if date() is > vD2. If so then
response.write vD1 & " to " & vD2
When I write out the variables, it is giving me the numeric value of these
dates:
334 to 105.473684210526

How can I convert these values to either yyyy/mm/dd or dd/mm/yy??????

[Robin]

Ok, barely wiser and still confused. This is the code:
vD1 = FormatDateTime("1/6/2004")
vD2 = FormatDateTime("1/19/2004")
If date() > vD2 Then
response.write "<option value='" & vD1 & "-" & vd2 & "'>" & vd1 & " to
" & vd2 & "</option></select>"
End If
the "If" is finding that date() is not > vD2
(date() = 3/3/2004; vD2 = 1/19/2004)

???????

[Robin]

Ok, if I instead use:
If formatDateTime(date())
It works.

"Robin" <rl*****@energymasterllc.com> wrote in message
news:AO*******************@bignews1.bellsouth.net. ..

Ok, barely wiser and still confused. This is the code:
vD1 = FormatDateTime("1/6/2004")
vD2 = FormatDateTime("1/19/2004")
If date() > vD2 Then
response.write "<option value='" & vD1 & "-" & vd2 & "'>" & vd1 & " to " & vd2 & "</option></select>"
End If
the "If" is finding that date() is not > vD2
(date() = 3/3/2004; vD2 = 1/19/2004)

???????

[Evertjan.]

Robin wrote on 03 mrt 2004 in microsoft.public.inetserver.asp.general:

vD1 = FormatDateTime("1/6/2004")

You should not use this, as the date 1/6/2004 can mean 2 different dates.

To me it is the first of June!

Always use "2004/1/6" =sixth of January
or "2004/6/1" =first of June
--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

[Noozer]

"Evertjan." <ex**************@interxnl.net> wrote in message
news:Xn********************@194.109.133.29...

Robin wrote on 03 mrt 2004 in microsoft.public.inetserver.asp.general:

vD1 = FormatDateTime("1/6/2004")

You should not use this, as the date 1/6/2004 can mean 2 different dates.

To me it is the first of June!

Always use "2004/1/6" =sixth of January
or "2004/6/1" =first of June

I with the world would move to one standard...

I prefer YYYY/MM/DD as you can sort chronologically on this very easily!

[Robin]

I did convert to yyyy/mm/dd as MySQL uses that format also. Now here's (yet
another) question regarding dates ...
I'm just testing this out but it's not working.
vDate = date()
(vDate = 2004/3/3)
vTomorrow = vDate + 1
(vTomorrow = 2004/3/4)

Ok. That's how the above is working and all is fine. Now, if I do this:

vD1 = formatDateTime("2004/1/1")
(vD1 = 2004/1/1)
vD2 = vD1 + 1
I get this error: Type mismatch: '[string: "1/1/2004"]'

So, I guess it's not really seeing vD1 as a date type.

[Aaron Bertrand [MVP]]

I strongly suggest using YYYYMMDD. It is the only format guaranteed to be
safe in SQL Server.

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


"Robin" <rl*****@energymasterllc.com> wrote in message
news:nB*******************@bignews1.bellsouth.net. ..

I did convert to yyyy/mm/dd as MySQL uses that format also. Now here's (yet another) question regarding dates ...
I'm just testing this out but it's not working.
vDate = date()
(vDate = 2004/3/3)
vTomorrow = vDate + 1
(vTomorrow = 2004/3/4)

Ok. That's how the above is working and all is fine. Now, if I do this:

vD1 = formatDateTime("2004/1/1")
(vD1 = 2004/1/1)
vD2 = vD1 + 1
I get this error: Type mismatch: '[string: "1/1/2004"]'

So, I guess it's not really seeing vD1 as a date type.

[Chris Hohmann]

"Noozer" <po********@127.0.0.1> wrote in message
news:ICq1c.681065$ts4.21511@pd7tw3no...

"Evertjan." <ex**************@interxnl.net> wrote in message
news:Xn********************@194.109.133.29...

Robin wrote on 03 mrt 2004 in microsoft.public.inetserver.asp.general:

vD1 = FormatDateTime("1/6/2004")

You should not use this, as the date 1/6/2004 can mean 2 different dates.
To me it is the first of June!

Always use "2004/1/6" =sixth of January
or "2004/6/1" =first of June

I with the world would move to one standard...

I prefer YYYY/MM/DD as you can sort chronologically on this very

easily!

How about ISO-8601?
Basic: YYYYMMDD
Extended: YYYY-MM-DD

Use basic with MS SQL Server and extended with Access. Here are some
articles:
http://aspfaq.com/show.asp?id=2040
http://aspfaq.com/show.asp?id=2214

HTH
-Chris Hohmann

[Himselff]

You can always analyse each section of ure string with mid, left and right
function , which mean that if u grab a date whit

MaDate = Format$(Date$, "yyyy/mm/dd")

left(MaDate,4) = year etc ...

so u can grab any piece and add wath u want or validate !

=)
--
*****************************************
Plus de café ? Trop de travail ?
Bloqué ? Désesperé ?
Va prendre l'air, fumer une cigarette,
Sa fonctionne a tout coup =)
************************************************** **
Fred

www.dmsinc.ca
"Robin" <rl*****@energymasterllc.com> a écrit dans le message de news:
nB*******************@bignews1.bellsouth.net...

I did convert to yyyy/mm/dd as MySQL uses that format also. Now here's (yet another) question regarding dates ...
I'm just testing this out but it's not working.
vDate = date()
(vDate = 2004/3/3)
vTomorrow = vDate + 1
(vTomorrow = 2004/3/4)

Ok. That's how the above is working and all is fine. Now, if I do this:

vD1 = formatDateTime("2004/1/1")
(vD1 = 2004/1/1)
vD2 = vD1 + 1
I get this error: Type mismatch: '[string: "1/1/2004"]'

So, I guess it's not really seeing vD1 as a date type.

[Robin]

I ended up using :
vd1 = cDate(vd1) + 1
It then reads it as a date and not a string

yay

"Robin" <rl*****@energymasterllc.com> wrote in message
news:nB*******************@bignews1.bellsouth.net. ..

I did convert to yyyy/mm/dd as MySQL uses that format also. Now here's (yet another) question regarding dates ...
I'm just testing this out but it's not working.
vDate = date()
(vDate = 2004/3/3)
vTomorrow = vDate + 1
(vTomorrow = 2004/3/4)

Ok. That's how the above is working and all is fine. Now, if I do this:

vD1 = formatDateTime("2004/1/1")
(vD1 = 2004/1/1)
vD2 = vD1 + 1
I get this error: Type mismatch: '[string: "1/1/2004"]'

So, I guess it's not really seeing vD1 as a date type.

[Evertjan.]

Himselff wrote on 03 mrt 2004 in
microsoft.public.inetserver.asp.general:

You can always analyse each section of ure string with mid, left and
right function , which mean that if u grab a date whit

MaDate = Format$(Date$, "yyyy/mm/dd")

left(MaDate,4) = year etc ...

No you cannot.

Format() does not exist in ASP VBS

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

[Chris Hohmann]

"Evertjan." <ex**************@interxnl.net> wrote in message
news:Xn*******************@194.109.133.29...

Himselff wrote on 03 mrt 2004 in
microsoft.public.inetserver.asp.general:

You can always analyse each section of ure string with mid, left and
right function , which mean that if u grab a date whit

MaDate = Format$(Date$, "yyyy/mm/dd")

left(MaDate,4) = year etc ...

No you cannot.

Format() does not exist in ASP VBS

Although you could borrow it from VB.
http://aspfaq.com/2313

[Evertjan.]

Chris Hohmann wrote on 04 mrt 2004 in
microsoft.public.inetserver.asp.general:

"Evertjan." <ex**************@interxnl.net> wrote in message
news:Xn*******************@194.109.133.29...

Himselff wrote on 03 mrt 2004 in
microsoft.public.inetserver.asp.general:

> You can always analyse each section of ure string with mid, left and
> right function , which mean that if u grab a date whit
>
> MaDate = Format$(Date$, "yyyy/mm/dd")
>
> left(MaDate,4) = year etc ...
>

No you cannot.

Format() does not exist in ASP VBS

Although you could borrow it from VB.
http://aspfaq.com/2313

No, then you would have to install something (VB6).

I wouldn't call that borrowing.

Do you call using jMail borrowing ?
--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

[Chris Hohmann]

"Evertjan." <ex**************@interxnl.net> wrote in message
news:Xn********************@194.109.133.29...

Chris Hohmann wrote on 04 mrt 2004 in
microsoft.public.inetserver.asp.general:

"Evertjan." <ex**************@interxnl.net> wrote in message
news:Xn*******************@194.109.133.29...

Himselff wrote on 03 mrt 2004 in
microsoft.public.inetserver.asp.general:

> You can always analyse each section of ure string with mid, left and > right function , which mean that if u grab a date whit
>
> MaDate = Format$(Date$, "yyyy/mm/dd")
>
> left(MaDate,4) = year etc ...
>

No you cannot.

Format() does not exist in ASP VBS
Although you could borrow it from VB.
http://aspfaq.com/2313

No, then you would have to install something (VB6).

You also have to install something to use jMail, ADO, MSXML, CDO, OWC or
anything else that is not built into ASP. It's unclear how that negates
my original assertion that one can borrow the formatting capabilities
available in VB6. Also note that only the MSSTDFMT.DLL library needs to
be installed, not MS Visual Basic 6.0

I wouldn't call that borrowing.
You are free to call it whatever you like.

Do you call using jMail borrowing ?

I don't use jMail, but if I did then yes I would call that borrowing.
-Chris Hohmann