How to add maturity date >= TODAY in the cue as table filter

Business Central/NAV Developers Forum
1

Hi Team,

I have a table called My Activities Cue which contains Deposits, T-Bills, Bond and there datatype is decimal while trying to add maturity date >= TODAY so as to display the data that are which the range, it turned TODAY to 02/04/19

Cue.PNG

MaturityDate.PNG

How can I solve the above problem?

Thanks

2

you need to use date filter

3

Then on activities page OpenPage trigger set the WORKDATE filter or TODAY date filter

4

Hi IMRAN, I appreciated.

I created a new field called maturity date filter and set its datatype to date; flowfilter and I also add the maturity = FIELD (Maturity Date Filter) in the table filter of the field with decimal datatype, Deposit.

In the page under OnOpenPage(), I wrote this code;

SETFILTER(“Maturity Date Filter”,’>=%1’,WORKDATE); //****02-05-19IB ***Maturity Date >= TODAY