logic help for months 1

[mtdew]

Currently I have:

IIF (ISNULL([first_pmt_effective]),"1st Pay N/A",IIF([Age Days]<68,Month(now())+1&"/1 and newer",Month(now())&"/1 and older"))

and it works except when it is December, then I get a "13/1 and newer" result.

How else can I phrase this to just use the correct months?

In Excel I can use:

=IF(MONTH(A2)+1=13,IF(OR(ISBLANK(E2),E2=0),"1st Pay N/A",IF($C2<68,(MONTH(A2)+1)-12&"/1 and newer",MONTH(A2)&"/1 and older")),(IF(OR(ISBLANK(E2),E2=0),"1st Pay N/A",IF($C2<68,MONTH(A2)+1&"/1 and newer",MONTH(A2)&"/1 and older"))))

 

[Andrzejek]

how about instead of:
[tt]
,Month(now())+1 & "/1 and newer",
[/tt]
you would have:
[tt]
,IIF(Month(now()) = 12, 1, Month(now())+1) & "/1 and newer",[/tt]

Code not tested.

Have fun.

---- Andy

 

[mtdew]

Works! Thanks!