Filter property for ADOTable

Hi Techies,

I have written following expression in Filter property of my TADOTable connected to SQL Server 2005, but it gives me an error....kindly help

Filter := 'CONVERT(VARCHAR(10),TaskStartTime,101)='+QuotedStr(FormatDateTime('mm/dd/yyyy', Now)) +
' or CONVERT(VARCHAR(10),TaskNextExecution,101)='+QuotedStr(FormatDateTime('mm/dd/yyyy', Now));

thanks in advance

Jeet

Replies

• Re: Filter property for ADOTable posted by Brian Hollister on Fri, 30 Jan 2009