Filter Posting Date

Dynamics 365 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