Max Month minus 1

[kev6brown]

Hi,

I have the expression - Count({<ADMIT_MNTH = {"$(=Max(ADMIT_MNTH))"}>}[Patient]) which gives me the max month but i know need the same expression but the previous month so MINUS 1

Thanks

Kev

[dplr-rn]

use addmonths function with -1

Count({<ADMIT_MNTH = {"$(=AddMonths(Max(ADMIT_MNTH),-1))"}>}[Patient])

[kev6brown]

Comes through as zeros

[dplr-rn]

check output of this expression in a text object and check

AddMonths(Max(ADMIT_MNTH),-1)

[Kushal_Chawda]

try below

assuming ADMIT_MNTH format is MMM YYYY.  In below set you can try giving actual format

Count({<ADMIT_MNTH = {"$(=date(addmonths(Max(ADMIT_MNTH),-1),'MMM YYYY'))"}>}[Patient])

[kev6brown]

That gives me the previous month but in the format 01/06/2020 maybe that's why

[dplr-rn]

@kev6brown wrap it with date and try