Setting a filter on a datefilter

nbangaza
nbangaza Member Posts: 30
edited 2010-03-17 in NAV/Navision Classic Client
I have created a variable NewDate datatype=flowfilter
and i have another variable CurrentDate datatype=date

on a form i want to be able to set a filter between CurrentDate and Newdate. meaning, if newdate = 03/04/10 and there are 5 records where the current date = 03/04/10 then the form must only display records that fall on that date.(03/04/10.

i tried saying setrange(currentdate, newdate); and that didnt work.

Comments

  • rmpatel22
    rmpatel22 Member Posts: 80
    Try SETFILTER(currentdate,'=%1', newdate);
    Rakesh Patel
    Navision Developer
  • kapamarou
    kapamarou Member Posts: 1,152
    nbangaza wrote:
    I have created a variable NewDate datatype=flowfilter

    What exactly do you want to achieve?
    Flowfilters are used to calculate flowfields. If you want to hide records from your form you will need to apply filters on the date field itself.

Categories