Writing an Expression that Limits results based on max Year and Max Date
I'm seeking help in writing an expression that will limit the results based on the max value date in two separate columns. The first column is a Fiscal Year (2014, 2013, 2012...) and the second column contains a Date (10/31/2014, 11/30/2014, 12/31/2014).
What I currently have returns results for the max Fiscal Year:
Re: Writing an Expression that Limits results based on max Year and Max Date
So I have a column that contains a Fiscal Year and a column with a Date (Quarter End Date). I want to see the data for a specific year and a specific Date (Quarter End). I tried the expression above and it did not work. What could I be doing wrong?