Working with dates...

[Noozer]

I'm using ASP to access an MS Access database. One issue that I'm constantly
having problems with is Date/Time records.

What I'd like to know is how does one work with date variables in ASP?

My current problem is this...

I have two variables, Mnth and Yr, which each hold an integer. Mnth holds
between 1 and 12 ( a month ), and Yr holds the desired year (2005 for
example).

With only these two variables how can I generate a full date to use in an
SQL query, such as:

SELECT * From Table WHERE DateAdded>??<date value here>??

[John Blessing]

"Noozer" <do*******@me.here> wrote in message
news:LI7xe.137500$El.57669@pd7tw1no...

I'm using ASP to access an MS Access database. One issue that I'm
constantly
having problems with is Date/Time records.

What I'd like to know is how does one work with date variables in ASP?

My current problem is this...

I have two variables, Mnth and Yr, which each hold an integer. Mnth holds
between 1 and 12 ( a month ), and Yr holds the desired year (2005 for
example).

With only these two variables how can I generate a full date to use in an
SQL query, such as:

SELECT * From Table WHERE DateAdded>??<date value here>??

Use a column type of datetime instead.
--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook

[Noozer]

"John Blessing" <jb@**REMOVE**THIS**Lbesoftware.com> wrote in message
news:s2*******************@newsfe2-gui.ntli.net...

"Noozer" <do*******@me.here> wrote in message
news:LI7xe.137500$El.57669@pd7tw1no...

I'm using ASP to access an MS Access database. One issue that I'm
constantly
having problems with is Date/Time records.

What I'd like to know is how does one work with date variables in ASP?

My current problem is this...

I have two variables, Mnth and Yr, which each hold an integer. Mnth holds between 1 and 12 ( a month ), and Yr holds the desired year (2005 for
example).

With only these two variables how can I generate a full date to use in an SQL query, such as:

SELECT * From Table WHERE DateAdded>??<date value here>??

Use a column type of datetime instead.

The column already is a DateTime... My problem is that my code only has a
month and year stored in variables. How do I convert that to a date to make
a valid comparison against the DateTime column?

[Bob Barrows [MVP]]

Noozer wrote:

I'm using ASP to access an MS Access database. One issue that I'm
constantly having problems with is Date/Time records.

What I'd like to know is how does one work with date variables in ASP?

My current problem is this...

I have two variables, Mnth and Yr, which each hold an integer. Mnth
holds between 1 and 12 ( a month ), and Yr holds the desired year
(2005 for example).

With only these two variables how can I generate a full date to use
in an SQL query, such as:

SELECT * From Table WHERE DateAdded>??<date value here>??

Read these and come back if you have further questions on the topic:
http://www.aspfaq.com/show.asp?id=2313 vbscript
http://www.aspfaq.com/show.asp?id=2040 help with dates
http://www.aspfaq.com/show.asp?id=2260 dd/mm/yyy confusion

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"

[Noozer]

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...

Noozer wrote:

I'm using ASP to access an MS Access database. One issue that I'm
constantly having problems with is Date/Time records.

Read these and come back if you have further questions on the topic:
http://www.aspfaq.com/show.asp?id=2313 vbscript
http://www.aspfaq.com/show.asp?id=2040 help with dates
http://www.aspfaq.com/show.asp?id=2260 dd/mm/yyy confusion

Very, very helpful stuff. Thanks!!!

[Phill. W]

"Noozer" <do*******@me.here> wrote in message
news:LI7xe.137500$El.57669@pd7tw1no...

I have two variables, Mnth and Yr, which each hold an integer.
Mnth holds between 1 and 12 ( a month ), and Yr holds the desired
year (2005 for example).

With only these two variables how can I generate a full date to use in an
SQL query, such as:

sSQL = "SELECT col1, col2, col3, ... " _
& "FROM Table1 " _
& "WHERE DateAdded >= #" _
& "#" & Right( "000" & Yr, 4 ) _
& "-" & Right( "0" & Mnth, 2 ) _
& "-" & "01" & "# "

HTH,
Phill W.