How to filter out the current month in a expression?

[Anonymous]

Hi,

I have the following expression:

Count({$<CaseClosed = {"=Date#(YRMON, 'YYYY-MM') > MonthStart(Today(), -10)"}>} DISTINCT CaseClosed)

This expression is including the current month, I will like to have as MonthStart last month, but I tried Today()-1 but it still displays the current month.

Any idea on how to do this?

[tresesco · Accepted solution]

May be this?

Count({$<CaseClosed = {"=Date#(YRMON, 'YYYY-MM') > MonthStart(Today(), -10)

                                                  AND

                                            Date#(YRMON, 'YYYY-MM') <= MonthEND(Today(), -1) "}>} DISTINCT CaseClosed)

I am not sure if you need MonthStart or MonthEND for the last month..check your logic and use it accordingly.