Hi Eric, IMHO this question does not makes sense. Dates are not stored with 2, 4 or whatever number of year digits. Dates are stored as... euhm... well...: dates!
I guess you might have problems caused by imported dates from a text source which did not include the century info. This way you can have dates in the year 16 instead of 2016. Those should be easily found with a simple query like (from the top of my head): //to be OS date settings independent: $date:=!0!//4d method editor will expand $date:=add to date($date;1000;1;1)//or whatever year you think will be incorrect, in this case everything before januari first 1000 query([myTable];[myTable]myDate < $date) HTH Koen Op 25-aug.-2016, om 16:22 heeft Eric Naujock <[email protected]> het volgende geschreven: > Is there a simple way to detect 2 digit years stored in the 4D database. Much > less be able to fix the 2 digit year and convert it to a proper 4 digit year. > I Had a utility that would try to convert is using the following. The code > runs on 4D v15.2 -------------------- Compass bvba Koen Van Hooreweghe Kloosterstraat 65 9910 Knesselare Belgium tel +32 495 511.653 ********************************************************************** 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] **********************************************************************
