VB.Net - Access DB

johneecc · August 7th, 2008, 03:10 PM

I am having a heck of a time trying to figure out what is wrong with this code. Trying to compare a system date with a date in an Access DB using a user defined date.

Initially, I had the compare in the Select Statement and then moved it into a Do While loop as a further test.

The results I am getting is as though the compare is only seeing the Month and Day and not the year. I am able to get the return of anything after today until 12/31/08.

Thanks for your help.
johnc

Anyone see anything wrong with these statements?

SQL statement version:

Code:

Command.CommandText = "SELECT PageIndex FROM CustomerPicks_Reviews WHERE (ItemNumber = '" & intItemNum & "') AND (ExpirationDate >= '" & Format(System.DateTime.Now, "MM-dd-yy") & "')"

Loop version:

Code:

            DataReaderIndex = CommandIndex.ExecuteReader()
            Do While (DataReaderIndex.Read())
                strExpirationDateDB = DataReaderIndex.GetValue(1).ToString
                MsgBox(strExpirationDateDB)
                If DataReaderIndex.GetValue(1).ToString >= Format(System.DateTime.Now, "MM-dd-yy").ToString Then
                    CmbBxSglOthIpsPage.Items.Add(DataReaderIndex.GetValue(0))
                End If
            Loop

gbianchi · August 7th, 2008, 03:31 PM

Hi there.. you have to format the table field to the same format as the other date...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

johneecc · August 7th, 2008, 04:11 PM

Hi,

Thanks for a quick response.

This Database change would be needed even when converting the system date to match the retrieved DB date string?

It is a little confusing.

gbianchi · August 7th, 2008, 04:19 PM

yes.. because the db format could be diferent from the system date..

Anyway, after revisit your code, You are selecting pageindex only and you are comparing it with a date?

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

johneecc · August 7th, 2008, 04:23 PM

I will change the DB to a date format and give it a try.

On the Loop version, I did pull the ExpirationDate along with the PageIndex. I didn't include the Select statement with the loop code.

Thanks.