Warranty report tweak?
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.
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.
Ideas?
1 Comment
[ + ] Show comment
-
Could you post the query that you have working? That would help us in resolving your specific issue. - grayematter 9 years ago
Answers (0)
Please log in to answer
Be the first to answer this question
