MySQL Date Range script

Hello All,

I am using Excel with a OBDC connection. I want to only pull data from a table from the past 30 days. I believe the below code should work, but it does not return any data. Any help would be greatly appreciated.

Please Login or Register  to view this content.

Thanks,

Lonney

MySQL isn't my thing, but it looks right

What happens when you run it directly against the db through phpmyadmin or the similar?

Oh, actually I don't think paymentdate in your where clause should have quotation marks

Thanks all!! I am at work right now, but will test when I get home and update. I really appreciate the help!!

Lonney

Sorry, I didn't answer the question from xlbiznes. I dont have any issues with any other sql statements that I have. There are also no errors from this statement, just no returned data.

Sorry, I didn't answer the question from xlbiznes. I dont have any issues with any other sql statements that I have. There are also no errors from this statement, just no returned data.

Ok - I am not a php guru, so I am likely doing something wrong. I tried to hard code the date as follows:

Please Login or Register  to view this content.

No errors, but no data. I also removed the quotation marks around paymentdate to no resolve. UGH!!

Ok. I made some progress, kind of.

If I run the below code and use another field which has just the month field which has 2 digits (Example: 11) or another field, the year field, which has 4 digits (example: 2014) the below code works. If I run the same code on the date field, which is formatted as: 11/4/2014, it brings in what appears to be random results. I tried changing the format in Excel to no avail. I also tried different ways to enter the date into the php statement to no avail. Any ideas?

Please Login or Register  to view this content.

Thanks everyone!

Lonney

Ok - I figured out the issue. The date is stored as a VarChar and not a date. Any ideas on how to approach this?

Make it a date field?

Thanks Kyle. Not that easy. I am going to try to use the STR_TO_DATE. Just not sure if Excel will reconize it. I will test wgen I get home.

Excellent - Thankyou!!

Not having any luck - going to go back at it tonight!

Update - I am half way there!!
Here is the issue:

The paymentyear works. paymentmonth works partially. paymentmonth recognizes single digit months, but does not recognize double digit months. For example: If the paymentmonth is "4" it works. If the paymentmonth is "10", "11" or "12" is does not work. It appears to only be recognizing the first digit, in this case, "1". Any help would be greatly appreciated!!

Please Login or Register  to view this content.

Another update:
If I hard code the paymentmonth in, it works correctly.

Please Login or Register  to view this content.