How To: View Paid Expense Reports from a Specific Date Range

Issue/Request:

Would like a script to view all paid expense reports for a specific date range

Resolution: 

Run SQL script to get the desired report. 

NOTE: The text in red will need to be changed to the desired date.

SELECT ExpenseReports.ShortReportID, ExpenseItems.Payee, ExpenseItems.Description, ExpenseItems.Amount, ExpenseItems.Miles, ExpenseItems.GLAccountNumber, 
a.FirstName + ' ' + a.LastName AS Submitter, ExpenseReports.BeginDate, ExpenseReports.EndDate, b.FirstName + ' ' + b.LastName AS Approver, 
c.FirstName + ' ' + c.LastName as Payer 
FROM ExpenseItems INNER JOIN 
ExpenseReports ON ExpenseItems.ReportID = ExpenseReports.ReportID INNER JOIN 
Production_Portal_PortalFx.dbo.PWUser AS a ON ExpenseReports.UserID = a.UserID INNER JOIN 
Production_Portal_PortalFx.dbo.PWUser AS b ON ExpenseReports.ApprovalManagerUserID = b.UserID INNER JOIN 
AuditTrail ON ExpenseItems.ReportID = AuditTrail.ReportId 
INNER JOIN 
Production_Portal_PortalFx.dbo.PWUser AS c ON AuditTrail.PerformedBy = c.UserID 
WHERE (ExpenseReports.BeginDate > '2014-01-01') and cast(audittrail.Description as varchar(50)) like 'Paid%' 
ORDER BY ExpenseReports.ShortReportID