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.

0 Comments   [ + ] Show comments




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.


Answered 07/15/2013 by: grayematter
Fifth Degree Black Belt