Alan, Sort the selection by the Date field, take the first Date, and then goto selected record (table;records in selection(table)), and get that Date.
This avoids loading much, except the date field sort. Hth! David Ringsmuth From: Alan Tilson via 4D_Tech Sent: Wednesday, October 11, 2017 4:30 PM To: 4D iNug Technical Cc: Alan Tilson Subject: Min/Max for Date Fields in 4D Greetings everyone, Is there a way to get the earliest and latest dates from a selection of records similar to using Min/Max for numerical data? I have sorted the data and captured the first and last dates but this seems rather a lot of work to get this info. I believe that I have also used Selection To Array to capture the dates in the array and then sorted the array. Surely there is something I've overlooked? Currently using v13.6. Thanks, Alan Tilson ********************************************************************** 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 **********************************************************************