Date Filter

upasanisandipupasanisandip Member Posts: 405
Hi,


I have created one table with 1 field of date data type.
I want to set date filter like in table G/L Account(15).
I know about Shift+F7 (in upper toolbar ),
I want to do it through program.


Pl. give any hints, suggessitions.

Thanks,

Sandip.

Comments

  • kinekine Member Posts: 12,562
    If you are talking about setting filter to FlowFilter field, you can do it in a standard way - through SETRANGE or SETFILTER.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • ara3nara3n Member Posts: 9,257
    One additional comment. Once you've set your filters through setrange and setfilter, you have to do calcfields on theh flowfields.
    example

    glacount.setrange("Date Filter",startdate,enddate);
    glacount.setrange("G/L Account",11200);
    glacount.calcfields(Balance);
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.