Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.