Current month YYYYMM convert to Prior Month YYYYMM

[ugurarslan]

Dear all,

a very simple question where I struggle already for a few days.

For the current invoice month I use [Invoice Year Month]={'$Current_Month_YYYYMM)'}.

Question, how can I get prior month or two months prior?

I tried [Invoice Year Month]={'$Current_Month_YYYYMM)',-2}. but it doesn't work.

Please help me.

Ugur

[agigliotti]

how does "Invoice Year Month" field looks like ? is a text or number ?

[ugurarslan]

the result for current month would be 201809.

[Ivan_Bozov]

Maybe try like this: [Invoice Year Month]={"$(=AddMonths(Current_Month_YYYYMM, -1))"}

[sunilkumarqv]

if field Current_Month_YYYYMM format would ne '201809' below should works

[Invoice Year Month]={"$(=(Current_Month_YYYYMM ) -1)"} - for previous month

[Invoice Year Month]={"$(=(Current_Month_YYYYMM) - 2)"} - for previous to previous month

[agigliotti]

maybe this:

[Invoice Date] = {">=MonthStart(AddMonths(Today(), -1))<=MonthEnd(AddMonths(Today(), -1))"}   prior month

[Invoice Date] = {">=MonthStart(AddMonths(Today(), -2))<=MonthEnd(AddMonths(Today(), -2))"}   two months prior

I hope it helps.

[OmarBenSalem]

Try this:

[Invoice Year Month]={"$(=date(monthstart(addmonths(today(),-1)),'MMYYYY'))"}