I am trying to get all records that have an admitance date of 18 months or longer. right now I use:
client.curr_program = 'RTC' AND
client.admission <= '2009-03-17'
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.