Hello Timothy, Great idea, but can this work on the current selection? Thanks, Alan
sent from my Note 4 On Oct 11, 2017 8:32 PM, "Timothy Penner via 4D_Tech" <4d_tech@lists.4d.com> wrote: 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:4d_tech-unsubscr...@lists.4d.com ********************************************************************** ********************************************************************** 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:4d_tech-unsubscr...@lists.4d.com **********************************************************************