This should be easy but I cannot figure it out. I have a database that has a date that an action must occur on. I want to be able to write a query that will create a report to hand to people that will show them say in 7 days this jobs require action. I will also want a 30 day and 60 day report most likely. All I need help with is the date calculation.
I'm thinking it might be using the DateAdd function but I'm not sure.