Query with date

lightfju · #1 (**permalink**) 09-20-10, 10:32

I am trying to get all records that have an admitance date of 18 months or longer. right now I use:
SELECT
client.cname,
client.curr_program,
client.admission
FROM
client
HAVING
client.curr_program = 'RTC' AND
client.admission <= '2009-03-17'
ORDER BY
client.admission ASC

Is there a way to have the date (bolded above) auto populate or do I need to change the date every time I run the query? I am using MySQL.

r937 · #2 (**permalink**) 09-20-10, 10:57

first of all, you should use WHERE, not HAVING

as for the date, sure, you can do it with an expression based on the current date...

Code:

SELECT cname
     , admission
  FROM client
 WHERE curr_program = 'RTC' 
   AND admission <= CURRENT_DATE - INTERVAL 18 MONTH
ORDER 
    BY admission ASC

lightfju · #3 (**permalink**) 09-20-10, 13:14

r937 YOU ROCK!!!!! I have been working 3 days on this and you fixed it with one simple statment! Thanks.

If you were here I would take you for a beer.

r937 · #4 (**permalink**) 09-20-10, 13:37

you're welcome

next time, i wouldn't wait 3 whole days

Internet Services

Web Development

Digital Marketing

Consumer Tech