Filter Posting Date

Business Central/NAV Developers Forum
1

Hi Everybody

I want filter the Item of customer buy range Posting Date >= 30D. And write code but not work

Please help me fix.

Thanks so much.

SETFILTER("Posting Date", '>=%1', CALCDATE('<CM-1M+1D>',EndingDate));

2

Hi,

Please write your code in OnPreDataItem of Item ledger entry

3

Thanks you manjusree. But it’s wrong at here ‘<=%1’

4

Store the calcdate in a variable on predata item and then use the variable in the filter on predata item and it will work.

5

Thanks you sbhatbng