selecting appointments for the last 12 months
Posted on 2012-03-13
I have a table called appointments, each appointment has a date, for example 13/03/2012 and a title...
I want to write a select statement to select all appointments in the last 12 monthS only , so for example if i ran the query today i would get all appointments back to 13/03/2011....i dont want to hard code the dates as i would like to run this anyday of the year and only get the previous 12 months of appointments.
Can anyone give me the syntax please?