Version LLBLGEN 3.1

How can I create the equivalent to this with predicate filters. Please Help. The query just compare dates and return records that match a range between two dates.

SELECT * FROM EHRNOTIFYQUEUE WHERE convert(char(10),NotifyDate,101) >= convert(char(10),GETDATE(),101) AND convert(char(10),NotifyDate,101) <= convert(char(10),GETDATE(),101)

Have you checked the docs, and tried some code and it did not work?

Hint: DBFunctionCalls

Just to answer your question. Yes I check the docs and I din't try any code because I din't find anything suitable for this. But thank for the hint. I wasn't familiar with the DBFunctionCalls. Sorry if I disturb you in some way.

Walaa wrote:

Have you checked the docs, and tried some code and it did not work?

Hint: DBFunctionCalls

Not at all

Good luck.