Page 1 of 1

custom date selection parameter

Posted: 20 Feb 2017, 10:22
by MartinD10
Sage HR v4.0 Sage Report Designer v1.3.2011.30

Complete newcomer to Sage but not reporting; trying to help a colleague. We have a custom report which calculates length of service to today's date 'NOW()'. My colleague works part-time and wants to replace this currentdate evaluation with a custom parameter - ie to be able to input a date (might be a month in the future or 6 weeks past) and have the results calculated and grouped accordingly. Is this possible, if so how? Currently the expression looks like this

TotalWholeMonths(vw_employment.StartDate, vw_employment.LeaveDate) / 12 >= 0 ? TotalWholeMonths(vw_employment.StartDate, vw_employment.LeaveDate) / 12 : TotalWholeMonths(vw_employment.StartDate, now()) / 12

many thanks

Martin

Re: custom date selection parameter

Posted: 20 Feb 2017, 10:31
by brucedenney
Why not keep it simple and add the dates as criteria?

in report designer

Report>Criteria>Add New Criteria