Actually this issue is related in that I have numerous people who have used a 2 digit year in their data entry and now they have a person who died in 16 and were born in 28 which makes them -12 years old right? According the the 4D date format that is right.
At least based on what I am seeing in 4D with the pivot dates that is right. The question is how to force people who are entering dates to put in a 4 digit year, and be able to find the 2 digit years and be able to correct them to a proper 4 digit year. Without messing up properly entered 4 digit years. ----------------------------------------------------------------------- MacCafe 4405 Talmadge St. Toledo, OH 43623 Eric Naujock - ACSA 10.2, 10.3, 10.4 Apple - ACTC 10.5, 10.6, 10.7, 10.8, 10.9, 10.10 http://www.mac-cafe.com email: e <mailto:[email protected]>[email protected] <mailto:[email protected]> AOL IM: erlic > On Aug 31, 2016, at 4:33 AM, Arnaud de Montard <[email protected]> wrote: > > >> Le 29 août 2016 à 15:34, Benedict, Tom <[email protected]> a écrit : >> >> 4D does support the datetime data type when the field is created using SQL >> commands. [...] > > Hi Tom, > if a date field is created with legacy tools, can it be used it as a datetime? > And an hour field? > > -- > Arnaud de Montard > > > ********************************************************************** > 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:[email protected] > ********************************************************************** ********************************************************************** 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:[email protected] **********************************************************************
