Hi
I have been given the solution by e/e to select 12 month appointments from my appointments table
Select * from TBLAppointments
where AppointmentDate > dateadd(m,-12,getdate())
this is good but if i run it it gives me all appointments from today 14/03/2012 back to 14/03/2011, how can i tweak it so it gives me data back from today to 01/03/2011...i need the full previous month also?
Thanks