Filter Records on DateTime Fields in a List Page

navuser1

Dear All,

I have a DateTime field in a List Page in NAV2016 Database. Now I want to filter the data on that Field.

Suppose I want to see the filtered records from 15/09/17 00:00 to 15/09/17 23:59.
But I would like to provide the (only) value 15/06/17 in the required field.

When I have given the input on that field to filter, it converts the value from 15/06/17 to 15/09/17 00:00. It does not convert the input value(15/06/17) into the range from 15/09/17 00:00 to 15/09/17 23:59.

How do I achieve it ?

Kindly reply.

Yury

Hi
15/09/17 00:00..15/09/17 23:59

navuser1

User will provide only 15/09/17 on the DateFilter Field of the Page. And the System will automatically convert the value from 15/06/17 to 15/09/17 00:00..15/09/17 23:59

Yury

For standard filter possibilities of NAV list pages its impossible to convert input dynamically. You should add your own field (date or text) for such purposes, convert it to DateTime and apply to DataSource on OnValidate trigger

navuser1

It is working fine in NAV2009.

MS has enhanced(removed) the feature from old to new

Slawek_Guzek

Hi,

The text entered in date/time filter field is converted into filter expression in codeunit 1 in MakeDateTimeFilter function, which in turn calls MakeDateTimeFilter funcion in codeunit 41.

You can try modifying that function to get what you need. Just be careful as it will affect the entire system, all places where a data/time filter is entered.

Slawek

navuser1

Slawek_Guzek wrote: »

Hi,

The text entered in date/time filter field is converted into filter expression in codeunit 1 in MakeDateTimeFilter function, which in turn calls MakeDateTimeFilter funcion in codeunit 41.

You can try modifying that function to get what you need. Just be careful as it will affect the entire system, all places where a data/time filter is entered.

Slawek

OK. I don't want to hamper the default system.