I did find the pivot date function. It was set to 19;20. I have reset it back to 19;85. The year the database was started. Though some cases do date well before then. But I am not going to roll that out until next week due to testing requirements.
> On Jan 18, 2020, at 12:58 AM, Peter Bozek <[email protected]> wrote: > > > > On Fri, Jan 17, 2020 at 10:33 PM Eric Naujock via 4D_Tech > <[email protected] <mailto:[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 > > May not be related, but note that, as far as I remember, 4D docs for SET > DEFAULT CENTURY command used to contain as example > SET DEFAULT CENTURY(19;20) > > I have seen this code in several databases. This line causes change of > behaviour at 1.1.2020. > > -- > > Peter Bozek ********************************************************************** 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] **********************************************************************
