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
How can I solve the above problem?
you need to use date filter
Then on activities page OpenPage trigger set the WORKDATE filter or TODAY date filter
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-19**IB ***Maturity Date >= TODAY