Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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)
Thanks but I get the same result. I need to filter Month names not month number