🚀 go-pugleaf

In article <77j1h0$sll12@forums.borland.com>, "John Staub" <bmds@send_me_nothing_worldnet.att.net> wrote:
>I have an SQL statement that I've struggled through that I need to add a
>date type function to.  The SQL statement is:
>select * from afcert.dbf where (sent = false) and (sealno is not null) and
>(crtmld is not null) and (wrtn is not null) and (prac is not null) and
>(wrtpass = true) and (pracpass = true)
>
>There is a date field in the table (crtmld is the field) that I would like
>to test.  Basically I want to know if (crtmld + 60 < date()) and if so,
>include it.  I understand SQL does not support the date() function, but does
>anyone know of an equivalent in SQL?  I've tried a variety of approaches to
>no avail.
>
>Thanks,
>
>John
>
>
John

I've had good luck using parameters.

q = new query()
q.sql = 'select * from mytable.dbf where datefield  + 60 < :mdate'
q.params["mdate"] = date()
q.active = true

Steve