I'd like to be able to run a warranty report to show systems that have will expire in the next year, as well as any that have expired in the previous year we may have missed. 

I have everything except figuring out how to limit the past expirations. I tried using a modified version of "date_add" like the line below it and using a negative number value but it just errored out. 


1 Comment   [ - ] Hide Comment


  • Could you post the query that you have working? That would help us in resolving your specific issue.
Please log in to comment

There are no answers at this time
Answer this question or Comment on this question for clarity