LOCAL lcMonth, lcYear, ldFirstDOM, ldLastDOM lcMonth = LEFT(THIS.Value, 2) lcYear = RIGHT(THIS.Value, 4) *-- convert value to a date ldFirstDOM = CTOD(lcMonth + "/1/" + lcYear) ldLastDOM = GOMONTH(ldFirstDOM, 1) - DAY(GOMONTH(ldFirstDOM, 1)) REPLACE MyTable.MyDateField WITH ldLastDOM...or something along those lines.