ldRolloverDate = date() update LOSIMPORT set dob= GOMONTH(dob, - 100*12) ; where dob > ldRolloverDate>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.
>update LOSIMPORT set dob=dob-100 years >>