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 <[email protected]> > 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:[email protected] **********************************************************************
