Capability not supported - Today() Function

[JonnyBee]

When I ran the query below I got an error message: Capability Not Supported.

SELECT COUNT( CardNo )
FROM "Clients.DB" Clients
WHERE ConExpiry >= Today()

 

[NotAllThere]

I don't think TODAY is supported in SQL. You could use a QBE or create the SQL on the fly (untested):

var
mySQL SQL
currentDate date
dbTables database
endVar

dbTables.open(":WORK:&quot
;maybe my setup but SQL always seems to want date format as MM/DD/YYYY
currentDate = = "'" + format("DY3,DO(%M/%D/%Y)", today() + "'"

mySQL = SQL

SELECT COUNT( Clients."CardNo" )
FROM "Clients.DB" Clients
WHERE
(Clients."ConExpiry" >= ~currentDate)

endSQL

if not mySQL.executeSQL(dbTables, "RIV:ANSWER.DB&quot then
errorShow()
return
endif

 

[NotAllThere]

Gremlins...
currentDate ="'" + format("DY3,DO(%M/%D/%Y)", today()) + "'"