I am actually searching against a date field. Using the query function. This is causing the dates before 1920 to not show up. I wound up finding them by splitting the dates up into components and then querying against the integer components.
> On Jan 17, 2020, at 8:02 PM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I don't see how the pivot year could have anything to do with it - that just > controls data entry when two digit years are entered. > > I don't have 17R5, but I don't see any problems with 17.3 or 18.0. > > Are you searching with date constants or using a string? > > John DeSoi, Ph.D. > > >> On Jan 17, 2020, at 3:33 PM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> I am running with 4d V17R5 and am seeing some odd date behaviors. When I >> search for a record with a date prior to 1921 I get all records in the >> database. Though most of the records are have dates newer than 1985. This is >> rather odd. I am not sure if this is due to 4D playing games with the pivot >> year that > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************