7 Replies Latest reply on Jun 18, 2016 11:54 AM by mycologist

    convert incorrect dates

    mycologist

      I am trying to figure out a way to convert about 5000 birthdates which have through the process of converting files to fm 14 become invalid. I took over the maintenance of a small database for the business I work at and the previous maintainer didn't set any sort of strict format for the date of birth field we have.

       

      It appears as though dates entered into the field as say xx/xx/xx have been converted into a format similar to xx/xx/20xx which labels many of our clients as yet to be born. I was wondering if there's a way to convert dates which may or may not have leading zeros in the day/month position or an incorrect century in the year position to something proper such as 0x/0x/19xx when the date is in the future based on the current date.