No, SQL does not work with the selection. I missed that requirement when I read the original post but I see it now.
-Tim Sent from my Verizon, Samsung Galaxy smartphone -------- Original message -------- From: Alan Tilson <alantil...@gmail.com> Date: 10/11/17 6:05 PM (GMT-08:00) To: 4D_Tech <4d_tech@lists.4d.com> Cc: Timothy Penner <tpen...@4d.com> Subject: RE: Min/Max for Date Fields in 4D 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<mailto: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<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 **********************************************************************