Setting a filter on a datefilter

nbangaza

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.

rmpatel22

Try SETFILTER(currentdate,'=%1', newdate);

kapamarou

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.