Date filter

mrigyamrigya Member Posts: 124
Hi All...I m new to navision ,want to apply filter on date field such that it should display the records less than, greater than and equal to the date given by user, all these records should be displayed at the same time.

Thanks and Regards.

Comments

  • DeepDeep Member Posts: 569
    Hit F1 or goto help in NAV.
    Search for Filters>Entering Criteria in Filters.
    Everything is explained there.
    Regards,

    Deep
    India
  • kinekine Member Posts: 12,562
    less than, equal to and greater than and all together? For me it means all records... ;-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • DeepDeep Member Posts: 569
    kine wrote:
    less than, equal to and greater than and all together? For me it means all records... ;-)

    lol :lol:
    Regards,

    Deep
    India
  • DenSterDenSter Member Posts: 8,305
    To clear a filter, you use SETRANGE, without values:
    MyRec.SETRANGE("My Date Field");
    
    Now it will remove the filter if there is any to begin with.
  • SavatageSavatage Member Posts: 7,142
    kine wrote:
    less than, equal to and greater than and all together? For me it means all records... ;-)

    Means the same thing to me :mrgreen:
Sign In or Register to comment.