Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

variable offset for date - a year ago

I have this sales report with the following columns:

1. Current Day Sales

2. Month to Date Sales (this Year)

3. Month to Date Sales (last Year)

I'm using a range variable for 0CALDAY for column 2 (Month to Date Sales this year). i'm having problem with column 3. how is it possible such that the date is automatically assigned to last year's values? using offset would mean -365, however, this may not work during leap years?

please help

Former Member
Not what you were looking for? View more on this topic or Ask a question