I can see value in being able to define relative dates for reports. A possible generic solution is to support relative date periods using a format something like
RelativeDate = BaseDate +/- X months +/- Y days
Where BaseDate (a drop down list) can be
- Today
- Start week
- Start Month
- Start financial year (a new Manager business parameter)
- Start of period (when specifying end of the period)
With month adjustments to achieve
- Year = 12 months
- Semester = 6 months
- Quarter = 3 months
Day adjustments to achieve
- Fortnight = 14 days
- Week = 7 days
- Last day month = First day next month - 1
I’m less sure of their value in one off date specification as the date picker works well for that