applying filter on date

vyanku

hi

I want to put a condition in setfilter on fromdate & todate.
setfilter("posting date",'>%1..<=%2',fromdate,todate);

"Posting Date" has to be between (greater than fromdate & less than or equals to todate).
It got compiled but while running the report it is showing me an error "Filter condition '>=%1..<=%2' is invalid".
How can I apply the filter on posting date. :-k

MBerger

use %1..%2 as your filter

vyanku

IF I used use %1..%2 then it will become as good as setrange("Posting Date",fromdate,todate)

Belias

at a first look at your post i was a bit disoriented, too...but after reading it carefully...

setfilter("posting date",'>%1&<=%2',fromdate,todate);

anyway...you wrote the solution by yourself 8)

greater than fromdate & less than or equals to todate

Sog

This comes straight from the help file in NAV

This example shows how to use the SETRANGE function to specify that you only want to see customers 100 through 200.

Customer.SETRANGE("No.", '100', '200');

The above statement is a quick way to set the same filter as:

Customer.SETFILTER("No.", '>=100&<=200'); 

@ Below
I stand corrected.
But nevertheless the correct syntax for the setfilter was in the helpfile

Belias

read carefully:
'>%1&<=%2'