DB2: Pulling YTD data on the first of the year
We have several Crystal Reports that use DB2 (AIX) queries as the backend of the report. They are year-to-date reports that, when run, show all days from 01/01 of that year through the date the report is run. I use something simple like this:
The problem is that, if the report is run on 01/01 of the next year, it has no data because it's only reporting on the first day of that new year. How can I get it to report on the previous year's data if run on the first week of the new year instead?
YEAR(column) = YEAR(current_date)The problem is that, if the report is run on 01/01 of the next year, it has no data because it's only reporting on the first day of that new year. How can I get it to report on the previous year's data if run on the first week of the new year instead?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER