I just import a text file into a dbf, the text file contained Date of Birth fields, but only with two digit years. Whent the text field was converted to a date field, it put some dates out of wack with reality, for instance a dob that had 18 for the year, was converted to 2018. I'm trying to figure out a way to replace the DOB year portion with the correct value.
Something like:
update LOSIMPORT set dob=dob-100 years
I can't just subtract (100*365), because that just doesn't calulate the right number of days, I was wondering if someone knew a way to do this.
Thanks