|
 |
asp_web_howto thread: Display last 3 months records
Message #1 by "Ryan vd Merwe" <ryan@8...> on Wed, 10 Apr 2002 19:14:48 +0200
|
|
Hi
How do I display the last 3 months records. I have a date column that
records the date of the record.
Thanks
Ryan
Message #2 by "Debreceni, David" <david_debreceni@r...> on Wed, 10 Apr 2002 13:42:39 -0400
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1E0B7.1C27EC60
Content-Type: text/plain;
charset="iso-8859-1"
use the sql between statement
where mydate between @date1 and @date2
and pass it the dates as params from asp or do the date right in SQL
David Debreceni
Senior Visual Basic/ASP Developer
xxx-xxx-xxxx x 1086
-----Original Message-----
From: Ryan vd Merwe [mailto:ryan@8...]
Sent: Wednesday, April 10, 2002 1:15 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Display last 3 months records
Hi
How do I display the last 3 months records. I have a date column that
records the date of the record.
Thanks
Ryan
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
Message #3 by "Ryan vd Merwe" <ryan@8...> on Thu, 11 Apr 2002 10:17:49 +0200
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0007_01C1E142.21A97790
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
RE: [asp_web_howto] Display last 3 months recordsThanks David
I'm quite new to asp, how do I do this in programming terms.
I understand to select between date1 and date2 but how do i work out the
vale of date2 if date1 is the current date?
-----Original Message-----
From: Debreceni, David [mailto:david_debreceni@r...]
Sent: 10 April 2002 07:43
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Display last 3 months records
use the sql between statement
where mydate between @date1 and @date2
and pass it the dates as params from asp or do the date right in SQL
David Debreceni
Senior Visual Basic/ASP Developer
xxx-xxx-xxxx x 1086
-----Original Message-----
From: Ryan vd Merwe [mailto:ryan@8...]
Sent: Wednesday, April 10, 2002 1:15 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Display last 3 months records
Hi
How do I display the last 3 months records. I have a date column that
records the date of the record.
Thanks
Ryan
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 ---
Message #4 by "Ajay" <ajayn@p...> on Thu, 11 Apr 2002 20:39:12 +0530
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0147_01C1E198.F0337FB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
RE: [asp_web_howto] Display last 3 months recordsYou can get the date2
as =3D DateAdd("m", -3, now()) and date1 as=3D now()
----- Original Message -----
From: Ryan vd Merwe
To: ASP Web HowTo
Sent: Thursday, April 11, 2002 1:47 PM
Subject: [asp_web_howto] RE: Display last 3 months records
Thanks David
I'm quite new to asp, how do I do this in programming terms.
I understand to select between date1 and date2 but how do i work out
the vale of date2 if date1 is the current date?
-----Original Message-----
From: Debreceni, David [mailto:david_debreceni@r...]
Sent: 10 April 2002 07:43
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Display last 3 months records
use the sql between statement
where mydate between @date1 and @date2
and pass it the dates as params from asp or do the date right in SQL
David Debreceni
Senior Visual Basic/ASP Developer
xxx-xxx-xxxx x 1086
-----Original Message-----
From: Ryan vd Merwe [mailto:ryan@8...]
Sent: Wednesday, April 10, 2002 1:15 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Display last 3 months records
Hi
How do I display the last 3 months records. I have a date column
that
records the date of the record.
Thanks
Ryan
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramm
e
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e
r-20
--- Improve your web design skills with these new books from
Glasshaus. Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramm
e r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e r-20 ---
--- Improve your web design skills with these new books from
Glasshaus. Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramm
e r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e r-20 ---
Message #5 by "Ken Schaefer" <ken@a...> on Fri, 12 Apr 2002 17:01:41 +1000
|
|
DateAdd()
DateAdd("m", 3, Date()) for example.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Ryan vd Merwe" <ryan@8...>
Subject: [asp_web_howto] RE: Display last 3 months records
: RE: [asp_web_howto] Display last 3 months recordsThanks David
:
: I'm quite new to asp, how do I do this in programming terms.
:
: I understand to select between date1 and date2 but how do i work out the
: vale of date2 if date1 is the current date?
: -----Original Message-----
: From: Debreceni, David [mailto:david_debreceni@r...]
: Sent: 10 April 2002 07:43
: To: ASP Web HowTo
: Subject: [asp_web_howto] RE: Display last 3 months records
:
:
: use the sql between statement
: where mydate between @date1 and @date2
:
: and pass it the dates as params from asp or do the date right in SQL
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #6 by "Ryan vd Merwe" <ryan@8...> on Fri, 12 Apr 2002 09:23:07 +0200
|
|
thanks!
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: 12 April 2002 09:02
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Display last 3 months records
DateAdd()
DateAdd("m", 3, Date()) for example.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Ryan vd Merwe" <ryan@8...>
Subject: [asp_web_howto] RE: Display last 3 months records
: RE: [asp_web_howto] Display last 3 months recordsThanks David
:
: I'm quite new to asp, how do I do this in programming terms.
:
: I understand to select between date1 and date2 but how do i work out the
: vale of date2 if date1 is the current date?
: -----Original Message-----
: From: Debreceni, David [mailto:david_debreceni@r...]
: Sent: 10 April 2002 07:43
: To: ASP Web HowTo
: Subject: [asp_web_howto] RE: Display last 3 months records
:
:
: use the sql between statement
: where mydate between @date1 and @date2
:
: and pass it the dates as params from asp or do the date right in SQL
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
|
|
|
View Cart
