Matrix filter
I am trying to filter data in the filter option. I only want the data where the posting date is in the current month of the same year. I can do this by creating a case in the sql query but I would rather not do it that way. I can do it in sql with a: datediff(mm, [posting date], getdate()) = 0 but I cannot figure out the syntax to use in the filter option.
|