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
C_DATE($1;$0) If (Count parameters=1) $0:=Date(String($1;ISO date GMT)) Else $0:=!00-00-00! End if ----------------------------------------------------------------------- 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 ********************************************************************** 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] **********************************************************************
