Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
how does "Invoice Year Month" field looks like ? is a text or number ?
the result for current month would be 201809.
Maybe try like this: [Invoice Year Month]={"$(=AddMonths(Current_Month_YYYYMM, -1))"}
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
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.
Try this:
[Invoice Year Month]={"$(=date(monthstart(addmonths(today(),-1)),'MMYYYY'))"}