I have two fields that I would like to join and create a variable:
Year field and Month field
Year = 2011, 2012, 2013....
Month = Jan, Feb,Mar.....
Create Variable = vMonthYear: Jan-11, Jan-12......
Could you possibly upload sample data or clarify your requirement.
You can do as below:
vMonthYear = Month&'/'&Year
Where You filter that month & Year. You have any datefield
Try with vlist,
Where MonthYear is MonthName(date) as MonthYear
month&'-'&right(year,2) as monthyear
Try This one
Retrieving data ...