SETRANGE with Datefilter

Comments

• Options

  Henry Member Posts: 18

  2002-12-05

  Thanks to Paul Baxter, the following solution:
  
  Hi Henry
  
  
  GETFILTER returns a text variable which contains the filter set on the field this could be "..01/01/02|01/02/02..28/02/02|01/06/02.." or something like that using English dates (that’s the month and date reversed for the yanks).
  What you need to use are the functions GETRANGEMIN and GETRANGEMAX, which return the bottom and top of the range respectively.
  Be warned the variable has to be filtered by a range or else a run time error will occur.
  
  
  Paul Baxter

  0
• Options

  knight Member Posts: 45

  2002-12-11

  Hey Henry,
  
  I would just like to add a different suggestion. The use of GETRANGEMIN and GETRANGEMAX is only useful if a simple date range is entered by a user eg "01/01/02..01/02/02"... however using a filter such as this
  "..01/01/02|01/02/02..28/02/02|01/06/02.." would make those commands useless..
  
  You were on the right track initially... making a Text variable such as vDateFilter, and then writing in code vDateFilter := Rec.GETFILTER(Date); (Rec being whatever the DataItem table name is)
  
  Once you have this filter in a text variable, instead of doing Item.SETRANGE("Date Filter",vDateFilter); you must use SETFILTER instead..
  Item.SETFILTER("Date Filter",vDateFilter);
  
  I'll explain the difference.. when you use SETRANGE, Navision thinks you are setting a range on a singular value of the data type of that particular field.. eg. When you do SETRANGE on a Date Field, the value you are setting the range on, must also be of type Date.
  
  If you use SETFILTER, it will accept anything you try and filter on, as long as it has been formatted to Text. Eg. on a Date field, you would specify a Date written as text (eg. '010102' not 010102D).
  
  The reason it was falling over for you previously, was that you were using Item.GETFILTER("Field name") which will return a Text, and then useing SETRANGE on a Date field with a Text. Hence, the conversion error.
  
  Sorry for the long explanation, but hope it helps.
  

  Henry wrote:

  Thanks to Paul Baxter, the following solution:
  
  Hi Henry
  
  
  GETFILTER returns a text variable which contains the filter set on the field this could be "..01/01/02|01/02/02..28/02/02|01/06/02.." or something like that using English dates (that’s the month and date reversed for the yanks).
  What you need to use are the functions GETRANGEMIN and GETRANGEMAX, which return the bottom and top of the range respectively.
  Be warned the variable has to be filtered by a range or else a run time error will occur.
  
  
  Paul Baxter

  0
• Options

  Henry Member Posts: 18

  2002-12-11

  Thanks Knight,
  This one works well. Such tips you gave makes this forum very usefull!
  Greetings,
  Henry

  0