Devart Forums

Hi,

I believe there is a bug in FilterSQL. WHen I filter on a date it gives no result. When I use the same filter string with the Filter property it works?

Is this a bug or should I prepare the statement differend for FilterSQL?

Could someone tell me what property is advised to use FilerSQL or Filter?

Statement:

FilterSQL='END_DATE='2-2-2005''

best regards, Hans

Problem is in DATE precision. For example, insignificant (for user) difference in one millisecond is significant for comaprison. To avoid the problem use '>=' operation instead of '='.