One of the common tasks a report writer can be asked to do is sort or limit information based on certain dates or date ranges. They could use SQL functions like:

matusetrans.actualdate >= dateadd(day, -7, convert(varchar, getdate(), 101))

workorder.reportdate >= getdate() - 7
 

po.followupdate - getdate() >= 0

matusetrans.actualdate …

One of the key things a reliability professional is asked to do is look at ways their organization should be measuring their performance against known metrics. One of the best lists I've found is SMRP's Metrics & KPI's list.¹ This is a list of recognized metrics and KPI's an organization …