Report for assets modified in past X days
I have a subordinate working on cleaning up our software and license assets and software labels in our k1000. I've added a custom field that he flags as he fixes a record/label and I have successfully created a report that will return everything with tthat flag set. But I would like to filter, or at least sort, that down by modified date, so I can just look at the past 7 days of changes, say.
Answers (1)
That will require adding a condition to the where clause in the SQL statement. the where clause would have
A77_AH.time > date_sub(current_date(), interval 7 day)
A77_AH is the appropriate Asset_History join. time is the timestamp field of the update. You can change the interval to whatever you like. Check the MySQL documentation for more details, http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-add.
