Welcome! Log In Create A New Profile

Advanced

Hfilter syntax

Posted by Joel 
Forum List Message List New Topic
Joel
Hfilter syntax
March 16, 2009 10:04AM
Hi there -

I'm new to Hfilters and could use some help on syntax.

I'd like to filter a file by the "EndDate" field such that only records where EndDate < Today() are returned.

So far I have - HFilter(HFMemberships, EndDate, -and then?

thx
Reply Quote
ICI
Re: Hfilter syntax
March 16, 2009 10:44AM
Create composite Key on that field and than

dDateToday is date=Datesys()

HFilter(HFMemberships, EndDate, dDateToday, dDateToday)

I think this is right, becouse I'm still use this kind of HFilter().

Happy WinDeving winking smiley
Reply Quote
DerekT
Re: Hfilter syntax
March 16, 2009 10:50AM
Joel 
sFilterRes = HFilter(HFMemberships, EndDate,"",DateSys()) 
HReadFirst(HFMemberships, sFilterRes)
will do what you need.

Also check out the use of queries which IMHO offer more flexibility.

Regards

DerekT
Reply Quote
Newer Topic Older Topic
Author:

Your Email:


Subject:
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: