Skip to Content
Former Member
Jan 04, 2011 at 04:01 PM

Need to read variable


Hi all,

I am on BW 3.5 and have a question about the BEx.

I have a sales report where the user can put in a month (single entry - calmonth/year). This works fine. However, one of the fields is 'Year-to-Date' sales. The kicker is that the 'Date' part of year-to-date is whatever was entered for the month; i.e. if the user enters '09/2010' for the date, then 'Year-to-Date' would be 01/2010 - 09/2010. If they enter '06/2009', then 'Year-to-Date' would be '01/2009' - '06/2009' and so on.

What I'd like to do is create a variable that somehow reads the year of the user-entered variable and then sticks an '01' on it to generate a range.

Does anyone know how to do this? Or does anyone have an alternative idea?