Getting results for this week

Hey guys. I have a problem I cannot figure out. I have a table with a date field and I need to get the results for the next week.

Basicaly it's checking estimated completion dates and getting the results for jobs that are due within the next week.

Table looks like this
JobID-->Primary
EstimatedCompletionDate-->Date
Year
Make
Model etc...

I need to get a list that shows all estimated completion dates between today and 7 days from now.

I know how to check for jobs due today, but it's the 7 days from now that is throwing me off, especialy if the month changes.

Any Ideas? Thanks!

Hi,

which database do you use in this case? The solution depends on the database.

Thomas

Sorry, I am using MySQL

Try something like:

SELECT * FROM theTable WHERE EstimatedCompletionDate>=NOW() AND DATEDIFF(EstimatedCompletionDate,NOW()) <= 7

Thomas

Hrrm I can't figure out why , but this doesn't work....Error near DATEDIFF(EstimatedCompletionDate,NOW()) <= 7

SELECT * FROM tblJobs WHERE EstimatedCompletionDate>=NOW() AND DATEDIFF(EstimatedCompletionDate,NOW()) <= 7

I chanfged the tbl name and the field name is correct.

Thanks!

Why MySQL version do you have ? DATEDIFF was added in MySQL 4.1.1

Thomas