Results 1 to 2 of 2

Thread: Query with date

  1. #1
    Join Date
    Sep 2010
    Posts
    14

    Unanswered: Query with date

    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.

  2. #2
    Join Date
    Sep 2010
    Posts
    14

    Red face oops...

    After looking things over better I realized that I posted this question in the wrong section. I am sorry and have posted in the correct section.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •