Thanks for the idea... very clever. Unfortunately 4D still won't do an indexed query in this case like it does when passed a literal.
> On Dec 3, 2018, at 7:49 PM, Keisuke Miyako via 4D_Tech <[email protected]> > wrote: > > SQL functions such as CURRENT_DATE() seems to return a TIMESTAMP, which may > or may not match a native date value. > > for that reason, a C_DATE FN wrapper method seems inevitable if you want to > query the database for date values using SQL. ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
