Filtering Data

[Pomna]

Hello Experts,

I need help with filtering data. Below is my code which works fine. I have  added a variable to the app and set it to default to 1 and  a variable editing box that allows a user to enter number of years to go back. I need the user to select a month name not month number. How do I go about that? Thanks

Sum({$<[Work Date.autoCalendar.Year] = {'$(=year(today()))'}
,[Work Date.autoCalendar.Month] = {'$(=month(AddMonths(Today(),$(vYearsBack)*-1)))'}
,[IS.Activity Type] = {[Enhancing]}
,[Supported Location] =- {'04'}>}Hours)

[Anil_Babu_Samineni]

May be ignore that field?

Sum({$<[month number]=, [Work Date.autoCalendar.Year] = {'$(=year(today()))'}
,[Work Date.autoCalendar.Month] = {'$(=month(AddMonths(Today(),$(vYearsBack)*-1)))'}
,[IS.Activity Type] = {[Enhancing]}
,[Supported Location] =- {'04'}>}Hours)

[Pomna]

Thanks but I get the same result. I need to filter Month names not month number