Unanswered: Add months to a date of type int with format YYYYMMDD
I am using db2 UDB400.
I am querying the transaction date, which is of Type INT formatted as YYYYMMDD. I need to add ex. 6 months to this date, then divide by 6 to get AVG usage for 6 months.
Ideally, if I can just add months to this format, I can change the months out to a parameter in Crystal reports.
Any help is greatly appreciated!