What about SQL? It works for me (only tested v16)... // find the Min C_DATE($blankDate) C_DATE($foundDate) Begin SQL SELECT MIN(DateField) FROM SomeTable WHERE DateField <> :$blankDate INTO :$foundDate; End SQL
// find the MAX C_DATE($foundDate) Begin SQL SELECT MAX(DateField) FROM SomeTable INTO :$foundDate; End SQL -Tim ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
