I’m wanting to have BAQ table criteria where JobHead ClosedDate is in current month and current year. I’m attempting to use the BAQ Constants within the ‘specified expression’ filter value as suggested here: Current Month Criteria on BAQ , but I must be missing something. What would that criteria look like in the expression editor?
Make a calculated bit field that returns true where the month and year parts of ClosedDate are equal to Constants.Month and Constants.Year, respectively, then set a subquery filter on that calculated field.
